Having backups of a database sometimes is not enough—you must have consistent, accurate backups (especially for master). If you back up a database that contains internal errors, the database has the same errors when you restore it.
Using the dbcc commands, you can check a database for errors before backing it up. Always use dbcc commands to verify the integrity of a database before dumping it. If dbcc detects errors, correct them before dumping the database.
Over time, you can begin to think of running dbcc as insurance for your databases. If you discovered few or no errors while running dbcc in the past, you may decide that the risk of database corruption is small and that you need to run dbcc occasionally. If the consequences of losing data are too high, continue to run dbcc commands each time you back up a database.
For performance considerations, many sites choose to
run dbcc checks outside of peak hours or on separate
servers.
See Chapter 10, “Checking Database Consistency,” for information about the dbcc command.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
