SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table Error's
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kenny782
Starting Member

6 Posts

Posted - 06/12/2013 :  10:06:27  Show Profile  Reply with Quote
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

USA
5071 Posts

Posted - 06/12/2013 :  12:55:36  Show Profile  Visit russell's Homepage  Reply with Quote
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?

Edited by - russell on 06/12/2013 12:56:42
Go to Top of Page

Kenny782
Starting Member

6 Posts

Posted - 06/12/2013 :  14:45:55  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000