| |
 |
Another
time saving feature in
SQL Backup is the
ability to back up multiple databases using a single command. Using
the standard T-SQL BACKUP syntax, you need to use multiple BACKUP
commands to back up multiple databases e.g.
To perform the same backup using
SQL
Backup, you
could issue the following single command:
Notice that we are using the <database> tag in order to
dynamically specify the folder and file name, which is another
SQL Backup
feature. In fact, if we wanted to back up all the databases on our
SQL Server instance, we could do the following, again using just a
single command:
Or we could do the inverse i.e. back up all but certain databases
e.g.
Discuss or comment on this article on our Facebook group.
Document history
| 7/1/2010 | Initial release. |
|
