Essential DBCC Commands
You should run the DBCC CHECKDB and DBCC CHECKCATALOG commands to detect database and table corruption, along with structure inconsistencies. Additionally, you might want to schedule these commands prior to or immediately after running a backup. Keep in mind that these commands should be run for all databases, excluding pubs and tempdb. This includes your user-defined database and master, model, and msdb.
NOTE
Because of improved data storage and built-in, real-time data checks, Microsoft no longer recommends running CHECKDB before or immediately after performing a backup. With previous versions, it was common to schedule CHECKDB to run as part of the backup/database maintenance task.
TIP
The easiest method to automate ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
