Backup and Recovery

SQL Server 6.5 provides improved backup and recovery capabilities. Specifically, the SQL Enterprise Manager Database Backup/Restore dialog box supports the following improvements:

SQL Enterprise Manager maintains a record of database backups, including backups that are made through other applications. You can use SQL Enterprise Manager to restore a database or table without knowing where the backup is stored. This makes it easier to restore a database backup and all of its associated transaction logs in the correct order. For backups from SQL Server 6.5 servers, SQL Enterprise Manager automatically presents a list of database backups, table backups, and transaction log backups for you to choose from.

Backup history is maintained in tables in the msdb database, even for the backups that were created by custom applications or third-party tools. The following tables hold the backup information: sysbackupdetail, sysbackuphistory, sysrestoredetail, and sysrestorehistory.

Table Backup and Restore

Point-in-Time Recovery