SQL Backup 7

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?