Restoring a SQL Server database marked as suspect

Have you encountered this error “spid13 Bypassing recovery for database ‘yourdb’ because it is marked SUSPECT”. One of my friends got this error on his SQL Server 2000 database. This error usually occurs when SQL Server is not able to access a database

If you plan to recover a corrupt database on your own, here are some simple solutions that may work:

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

3 comments:

Jayaprakash R
said...

0. Convert the database from Suspect mode to emergency mode.1. Rebuild the Transaction Log using dbcc_rebuildlog command. This will create the transaction log in new location.2. Detach the database.3. Delete the old transation file.4. Copy the new transaction file to the location where the mdf file exists.5. Attach the database, specify the mdf file location.6. You can see the database in normal mode and ecovered from Suspect mode.