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 11-1 illustrates the strategy used to reload databases.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
