Reload Strategy

Reloading involves restoring a clean database from backups.

When convenient, load the most recent clean database dump, and apply the transaction logs to restore the database. load database clears the suspect page information from the master.dbo.sysdatabases and master.dbo.sysattributes system tables.

When the restored database is online, dump the database immediately.

This figure illustrates the strategy used to reload databases.

Reload strategy
Graphic describing the steps for dumping and reloading a database.