What are the challenges you face when working across database platforms? Take the survey
Options

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

bdillbdill Posts: 42 Bronze 2
edited October 20, 2007 12:19AM in SQL Backup Previous Versions
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.

Comments

  • Options
    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
  • Options
    bdillbdill Posts: 42 Bronze 2
    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!
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.