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.

Figure 12-1 illustrates the strategy used to reload databases.

Figure 12-1: Reload strategy

Graphic describing the steps for dumping and reloading a database.