Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Corruption in user Database, Unable to repair using DBCC checkdb Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 2:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 8:36 AM
Points: 3, Visits: 90
Hi Folks,

We are receiving following message on one of the user databases and unable to repair via DBCC check DB. ALso, we don't have clean backups for last 3-4 months. Please advise on how to fix the issue.

Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1:
Attribute of row in sys.columns does not have a matching row in sys.objects
Post #1561368
Posted Monday, April 14, 2014 2:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 42,774, Visits: 35,871
CheckDB won't fix that.

Either you have metadata corruption or the DB was upgraded from SQL 2000 and someone went messing with the system tables back then.

Script all objects, export all data, recreate the DB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1561370
Posted Monday, April 14, 2014 12:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 8:36 AM
Points: 3, Visits: 90
Thanks Gail..
Post #1561639
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse