| |
 |
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.
Discuss or comment on this article on our Facebook group.
Document history
| 7/1/2010 | Initial release. |
|
