| |
 |
It's a
common requirement that a backup file be named with a certain
naming convention, so as to allow for it to be quickly identified
to as its contents and date it was created. Using standard T-SQL
BACKUP syntax, you must explicitly name the backup files. To name
your files dynamically, you would need to write additional scripts
to form the backup file name.
With SQL Backup, you can use tags to dynamically name your backup
file. You can use the <TYPE> tag to identify the type of
backup the file contains e.g.
You can also use the <SERVER>, <INSTANCE> and
<DATABASE> tags to identify the source of the backup file
e.g.
Lastly, there is the <DATETIME> tag that allows you to add a
timestamp to the name, and also format the timestamp in various
ways e.g.
You can combine all the above tags to generate a file name e.g.
Notice that in the above example, tags were used in place of
subdirectory names. If the subdirectory does not exist, SQL Backup
will create it for you (if it has the necessary permissions) prior
to backing up your database.
Finally, you can establish a standard naming convention, and simply
use the <AUTO> option to generate a file name using that
standard naming convention.
Discuss or comment on this article on our Facebook group.
Document history
| 7/12/2010 | Initial release. |
|
