How does v6.4 restore LATEST_ALL log backup files?
Does it restore
- only the log backup files AFTER the latest_diff file? (either by LSN, or by file timestamp?)
or restores ALL LOG*.sqb file in the directory?
SUNDAY = FULL backup
MONDAY - FRIDAY = DIFF backup, say 5 am
HOURLY = LOG backup, say every :30
If I want to recover to Wednesday 7:30 am with LATEST_FULL
SQL Backup will restore
- Sunday FULL
- Wednesday 5 am DIFF
- all the log after 5 am? namely 5:30, 6:30, 7:30
from the Help file
You can also use the SQL Backup command line or extended stored procedure to restore a database using all the latest backups for a particular database (including the latest full backup, a subsequent differential backup, and all available transaction log backups). Use the RESTORE command with the LATEST_ALL keyword. For example:
SQLBackupC -SQL "RESTORE DATABASE Sales_Prod FROM DISK = 'C:\Backups\Sales*.sqb' LATEST_ALL WITH RECOVERY "
will restore the latest full backup of the Sales_Prod database, followed by the most recent differential backup, and then finally the most recent transaction log backups.