How can we help you today? How can we help you today?

How does v6.4 restore LATEST_ALL log backup files?

My question is

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?

e.g.
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.
jerryhung
0

Comments

1 comment

Sort by
  • petey
    RESTORE_ALL will use differential backups where available, and restore only transaction log backups made after the differential backup.

    Thanks.
    petey
    0

Add comment

Please sign in to leave a comment.