This is a great time saving feature, and also a pet favourite of
mine, and has been available since MiniSQLBackup 2, before it was
acquired by Red Gate and relaunched as SQL Backup.
There will be situations when you need to restore a series to
transaction log backups to recover a database. Using the
standard T-SQL syntax, you will need to identify, then restore each
transaction log separately e.g.
Using SQL Backup, you just issue a
single command to restore all the transaction log backups it finds
in the provided folder e.g.
You backup files can be split across multiple files, or spread
across multiple folders. SQL Backup will automatically
identify, group and restore all the log files in finds in the
correct order e.g.
This is a handy feature if you have a lot of transaction log
backups to restore, especially those split across multiple
files.
Document history
7/1/2010 | Initial release. |