Table Error's - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Table Error's

Author

Topic

Kenny782
Starting Member

6 Posts

Posted - 2013-06-12 : 10:06:27

I have a SQL 2000 server that is providing data to a program called Macola.

As of about a week ago my backups started failing, I ran a DBCC and I got the following:


Server: Msg 8928, Level 16, State 1, Line 2
Object ID 12, index ID 0: Page (1:10) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 2
Table error: Object ID 12, index ID 0, page (1:10), row 106. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 236 and 24.
Server: Msg 8944, Level 16, State 1, Line 2
Table error: Object ID 12, index ID 0, page (1:10), row 106. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 19 and 193.
DBCC results for 'DATA_300'.
DBCC results for 'sysobjects'.
There are 887 rows in 23 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 2054 rows in 350 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 12367 rows in 435 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 130 rows in 27 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 50 rows in 2 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 33 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 299 rows in 10 pages for object 'sysdepends'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysdepends' (object ID 12).

I can upload the whole log if it helps but everything else came back normal. Above is the first 28 lines.
Since I can't get a backup and I'm not completely sure how to fix it I'm unsure how to proceed.

Thanks alot for any help,

Kenny

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-06-12 : 12:55:36

I wouldn't worry too much about sysdepends being corrupt but...

I would be worried that whatever caused it is waiting to happen again and do something much worse.

Why are your backups failing? I would be VERY worried about this.

Do you have a recent good backup?

Did you recently run out of disk space or have a hardware failure/server crash?

Did you recently apply a service pack and run out of space whole doing it?

Kenny782
Starting Member

6 Posts

Posted - 2013-06-12 : 14:45:55

Do you have a recent good backup? Not of DATA_300, the backups are failing because backup exec is set to skip if a consistency check fails. I guess I could run a backup withing SQL mgr itself. I'm just a consultant here but they don't have anyone else to look at it.

Did you recently run out of disk space or have a hardware failure/server crash? No, could have been a power failure nobody told me about but otherwise no failures.

Did you recently apply a service pack and run out of space whole doing it? No

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources