SQL Server Performance Forum – Threads Archive

DB corrupt-any other solution beside restore Bkupd

One of our server encounter the error follow, after reboot, the error remain.
Appreciate if anyone could provide suggestion for recovery before last option.
My last resort is to restore from Backup.
Really appreciate
./Thank you
FSSpore DBCC CHECKDB ON NSQL…
Msg 2503, Level 16, State 1
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=97501; page# pointing to this page=97143; previous page# indicated in this page=102260)
Msg 7930, Level 16, State 1
Table Corrupt: keys in left child is not less than the parent key; check left child page 89859.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

You might wanna repair allowing DBCC to get rid of bad data. If you require 100% of your data, restore is your best bet.

Try DBCC CHECKALLOC WITH REPAIR_REBUILD and DBCC CHECKDB WITH REPAIR_REBUILD. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanx everyone for reply. Tried but
DBCC CHECKALLOC WITH REPAIR_REBUILD –
MSSQL 65 does not allow parameter repair_rebuild. Appreciate

I had same similar problem with SQL 7.0, only way was migrate to 2000 and run DBCC CHECKDB with option REPAIR_ALLOW_DATA_LOSS, becase this option dos not work in SQL 7.0 Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

When we run dbcc checkalloc FOR THE DATABASE ON MSSQL 6.5
the following eror message appear in full page, it seems a particular table page allocation has been corrupted. Under this condition, what is the better suggestion to rectify this ? Thank you and really appreciate your comments.
best regards
fs Msg 2540, Level 16, State 1
Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=22528 extent id=22728 logical pg#=22728 object id on extent=1168007192 (object name = ITRN) indid on extent=2
Msg 2540, Level 16, State 1
Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=89856 extent id=89856 logical pg#=89860 object id on extent=1168007192 (object name = ITRN) indid on extent=2
Msg 2540, Level 16, State 1 …
…
Msg 2540, Level 16, State 1
Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=159744 extent id=159824 logical pg#=159826 object id on extent=1168007192 (object name = ITRN) indid on extent=0
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

What is the service pack level on SQL Server? The SQL Server documentation recommends setting databases to "read only" or "single user" mode when running DBCC NEWALLOC on them to avoid spurious errors caused by in-progress transactions. In most cases these errors are 2540 or 2521 errors. This service pack greatly reduces the probability of getting these spurious 2540 and 2521 errors while users are updating the database.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>