Creating subfolders for each database

JonathanJonathan Posts: 4
edited March 15, 2010 3:06PM in SQL Backup Previous Versions
Hi,

I make backups (ca. 20 databases per instance) and store two sessions of them on a SAN (clustered environment) and about twenty sessions on a NAS.

For the Backup location (= SAN) it's possible to create a subfolder for eacht database.

My question is if it's possible to use the 'creating subfolders for each database' option for the Network copy location (= NAS)? I couldn'y find that by myself.

Gr. Jonathan

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Thank you for your post into the forum.

    To achive your goal, simply use the <database> file location tag to create a sub folder of the database name.

    In the Copy To path simply add the <database> tag to the end of the path, for example:

    \\MyServer\Share\<database>

    This action will create a sub folder of the database name and copy the backup file into the new sub folder. Further information of the File Location Tags can be found in the SQL Backup Help Information.

    I hope the above answers your question.
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.