Page History
...
You can also perform an instant restore through the CLI. Additional options can be set in the SQL Safe Restore wizard, from which you can generate a CLI script that includes the specified wizard settings.
...
SQLsafeCmd.exe InstantRestore <database> <full_backup> -diff <diff_backup> -log <log_
...
backup>
The following three options are specific to a backup set:
- BackupFile (if the backup set is striped)
- BackupSet
- Password (or or EncryptedRestorePassword)
Where these options appear in the command determines to which backup set they are applied. When you encounter one of these options, it is applied to the full if no -Diff/-Log option is yet encountered, otherwise it is applied to the most recent -Diff/-Log. For example, if you want to instantly restore the following backups:
- Full backup, 2 stripes, backupset 2, encryption key "full"
- Diff backup, 2 stripes, backupset 3, encryption key "diff"
- Log backup, 2 stripes, backupset 4, encryption key "log"
Use the command:
SQL SafeCmd SQLsafeCmd InstantRestore Northwind "C:\Backup\Northwind_Full (1 of 2).safe" -BackupFile "C:\Backup\Northwind_Full (2 of 2).safe" -BackupSet 2 -Password "full" -Diff "C:\Backup\Northwind_Diff (1 of 2).safe" -BackupFile "C:\Backup\Northwind_Diff (2 of 2).safe" -BackupSet 3 -Password "diff" -Log "C:\Backup\Northwind_Log (1 of 2).safe" -BackupFile "C:\Backup\Northwind_Log (2 of 2).safe" -BackupSet 4 -Password "log"
For more information about available available instant restore options, see the usage statements in the CLI Help. To view the CLI Help, type SQLsafeCmd help instantrestore.
...
SQL Safe is
...
a high-performance backup and recovery solution for your SQL Servers. Learn more
...