O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required