Additional Database Information
The following sections list tips and tricks that can help improve the management of databases. These tips can simplify database maintenance and improve database recoverability.
Tip 1: Document the Database
Always document the configuration of the database after it has been modified. This is in addition to backing up the master database. The easiest way to document the configuration of a database is to use the sp_helpdb command. You should save the output from the command to a text file (preferably somewhere other than the server's hard drive).
Tip 2: Take Advantage of the model Database
Use the model database to simplify object creation. The model database enables you to define a template for the creation of new ...
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.
