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 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.