SQL Backup 10

Restoring multiple backups

You can restore multiple full, differential, and transaction log backups that belong to the same backup set using the Restore wizard. For example, you can restore a full and differential backup for the same database at the same time. Details of how to do this are given in step 1 (select backups).

You can restore the latest set of backups for a particular database (the latest full backup, a subsequent differential backup and all available transaction log backups) using the Schedule Restore Jobs wizard or the LATEST_ALL argument when using the command line or extended stored procedure. See Scheduling restore jobs or LATEST_ALL in The RESTORE command for more information.

You can restore multiple transaction log backups for a particular database using the command line or extended stored procedure. See The RESTORE command for more information.


Didn't find what you were looking for?