June 27, 2005 at 10:35 am
What dbrecover command does? When it has to be run?
Thank you for your help,
a_k_
June 27, 2005 at 10:43 am
dbrecover???? Is that a custom procedure?
Definitely not something built-int!
* Noel
June 27, 2005 at 11:06 am
It is one of the DBCC Commands of SQL Server. When our DB became suspect it was recommended by Microsoft support to call this command for recovery purpose. But what exactly it does?
Now we have situation of corrupted indexes:
- 4 errors Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '163030314f564d30353034200' in index page (1:40729731), index ID 0, database 'MyDB'..
- 162 consistency errors found by checkDB like:
Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 1141579105, Index ID 0. Keys out of order on page (1:40729731), slots 14 and 15.
Server: Msg 2512, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 0. Duplicate keys on page (1:40729731) slot 28 and page (1:40729731) slot 29.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 2. Keys out of order on page (1:41115503), slots 428 and 429.
Should I try this command first (with Checkpoint call after that) or just rebuild all the indexes?
Thank you,
a_k_
June 27, 2005 at 12:42 pm
I would drop and recreate those indexes. No need for anything like DBCC DBREPAIR !
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply