How can we help you today? How can we help you today?

Feature Req: one folder per DB using <AUTO> variable

With frequent log backups for multiple databases, my backup folder gets unweildy with several hundred files in the same folder. It would be very nice to be able to specify a subfolder to use for each database via the <AUTO> variable.

ex:
<DATABASE>\<DATABASE>_<TYPE>_<DATETIME yyyy-mm-dd>

Then each database would have its own subfolder of the same name.
bdill
0

Comments

3 comments

  • Jason Cook
    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
    Jason Cook
    0
  • bdill
    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!
    bdill
    0
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.