Summary
Maintaining a good set of database backups and knowing how to use them to recover a database is one of the most important responsibilities of a DBA. Use the ideas and suggestions in this chapter to help build your own backup and recovery plan.
SQL Server 2000 has three different recovery models—simple, bulk logged, and full.
Database backups can be complete backups, which are full backups of the data and database objects, or differential database backups, which are just the data that has changed.
Transaction log backups are incremental backups that reflect the changes in the database since the previous transaction log backup or database backup.
Users can still implement the database during backups.
Use the header information on backup devices ...
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.
