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 ««12

Dbcc checkdb says 0 errors but SQL error 823 produced Expand / Collapse
Author
Message
Posted Monday, May 26, 2014 6:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 8, 2014 7:00 AM
Points: 25, Visits: 41
Sometimes due to high page level corruption the DBCC CHECKDB command refused to repair the SQL database and shows consistency failure errors. So if you have good backup then restore it otherwise in this condition to resolve it the use of external agent is more admirable.

SSMS Expert
Post #1574510
Posted Tuesday, July 22, 2014 1:06 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
I've run dbcc checkdb(MyData) but that said 0 errors found 0 errors repaired.


Did you disconnect all users/connections from the database first?
http://msdn.microsoft.com/en-us/library/ms345598(v=sql.105).aspx

I imagine there are sections that dbcc could have missed. It could have been a temporary allocation of memory as mentioned earlier and the bad sector being deallocated for the moment as Gail mentioned.
Post #1595250
Posted Tuesday, July 22, 2014 1:11 PM


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 @ 1:12 AM
Points: 43,008, Visits: 36,166
Please note: 2 year old thread.

Edit: and checkDB does not require users to be disconnected, it's an online operation.



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 #1595256
Posted Tuesday, July 22, 2014 2:34 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
I did find something interesting on Books Online regarding CHECKDB : Just wanted to note here >
"databases that are created on SQL Server 2005 and later should never contain incorrect counts; however, databases that are upgraded to SQL Server 2005 and later might. "
Wow, another fine detail to memorize :)

http://msdn.microsoft.com/en-us/library/ms176064(v=sql.105).aspx
Post #1595278
Posted Tuesday, July 22, 2014 3:13 PM


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 @ 1:12 AM
Points: 43,008, Visits: 36,166
Hence the standard recommendation to run DBCC UpdateUsage when upgrading a DB. And 2008 still has incorrect counts occasionally.


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 #1595289
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse