In the event of database corruption, use the following guidelines to restore the database to its condition prior to when the corruption occurred.
If your database becomes corrupt, do not perform a full backup. Doing so will destroy your active log file.
-
Perform an immediate backup of the corrupted database's transaction log.
-
Attempt to repair the database using consistency checks and other available tools. If the repair attempt fails, follow steps 3 through 5 to restore the database.
-
For information about checking database integrity, see Database Integrity.
-
For detailed information regarding disaster recovery, see the online documentation for Microsoft® SQL Server.
-
-
Apply the last full backup.
-
Apply the last differential backup.
-
Apply all transaction log backups in succession, from the most recent (after the last differential backup) up to and including the transaction log backup obtained immediately after the database failure.