How to Reload a Suspect User Database

If all other methods of restoring a user database marked “suspect” have failed, perform the steps in this section to reload the suspect database from a known, clean backup.

Reload the suspect user database from backup by following the steps in “Recovering a Database: Step-by-Step Instructions” in the System Administration Guide. It is very important to follow that procedure to ensure that the segment sizes and locations are created in the proper order, or your database will not reload properly.

If you cannot drop the database using the normal procedure, use the dbcc dbrepair command. Refer to “How to Drop a Database When drop database Fails”.

For more information about reloading databases, refer to “Error 2558”.