Creating a Backup Schedule

You know how to schedule backups of transaction logs and databases, but when should you back them up? To answer that question, you are going to create two separate categories: Category 1 consists of actions performed in a database that warrant an immediate database backup. Category 2 consists of scheduling backups that meet your restore needs.

Category 1: Actions that Warrant Dumping a Database

In general, you are aware that you should perform database backups on a timely schedule. Backups should also be performed after certain actions occur in a database to ensure full and easy restores.

User Databases

After you perform certain actions on a user database, you should back up the database as soon as possible to guarantee ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.