Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant

Using Backup Strategies

Table 14-1 lists backup strategies you may want to use. As you can see, these backup strategies are based on the type of database as well as the type of data. When planning a backup strategy, remember the following:

• The master database stores important information about the structure of other databases, including the database size. Any time database information or structure changes, master may be updated without your knowing about it. For example, the size of most databases changes automatically, and when this happens master is updated. Because of this, often the best backup strategy for master is to schedule backups every other day and to rotate through several backup sets so that you can go back to several different versions ...