Comments
3 comments
-
You can actually do something very similar in SQL Backup 5 already, there are two ways to achieve what you are after:
1) insert the <database> tag into the folder name when performing the backup, so for example the folder is "c:\backups\<database>\" and the filename is "<auto>.sqb".
2) Using the "Tools > Options" menu, you can change the default to insert this tag automatically for all subsequent backup tasks and job tasks.
If you need any more information on how this works, feel free to follow-up.
Hope that helps,
Jason -
Ok. Thanks. I'm an idiot. I have never clicked on the ... to browse for a folder - thus I never saw that checkbox option, nor did I think to put the <database> variable in the Backup folder.
I didn't think that the "backup folder" could be "variable-ized". I was thinking that only the "file name format" had that feature.
Thanks again! -
You can use the any of the tags anywhere in the path.
If using database names as part of the path, you do need to be careful with the naming conventions if you have multiple instances containing databases of the same name, otherwise backups of one database from one instance may overwrite backups of an identically named database from another instance.
Add comment
Please sign in to leave a comment.
ex:
<DATABASE>\<DATABASE>_<TYPE>_<DATETIME yyyy-mm-dd>
Then each database would have its own subfolder of the same name.