March 1, 2012 at 12:49 pm
What is allocation error and consistency error ? I found this words when I ran DBCC checkdb command. And how can we overcome from this error?
March 1, 2012 at 12:51 pm
In short, you have a corrupt database. (allocation errors have to do with errors in the way that pages are linked to objects, consistency errors have to do with the structure of a page)
Do you have a clean backup (a backup taken before the corruption occurred)?
Please run the following and post the full and complete results.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 1:01 pm
Yes, I restored recent backup and ran DBCC checkdb. Now no errors.
One more question... Can we ran DBCC Checkdb on any size of database ? If any DB is of large size than Is it advisable to run this command because according to me DBCC checkdb command will check each and every tables of Database.
March 1, 2012 at 1:39 pm
You absolutely have to do consistency checks of any database, no matter how big. If you don't, you'll never know when something happens to corrupt some pages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply