O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Backup and Media Fundamentals

Information about backup history, backup devices, and media sets are stored in the system msdb database. This information is extremely useful in helping to understand and manage backups, such as to determine what databases and files have been backed up, what type of backups have been performed, and which backup sets are available for restore. Basic backup set and media set terminology are unchanged since SQL Server 2000, and the information in the backup history tables of both is similar, but with SQL Server 2005 there are some additional columns in the tables and one completely new table, called backupfilegroup.

The following system tables within the msdb system database store history information about backups:

  • Backupfile ...

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