Creating subfolders for each database

Jonathan

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

Eddie D

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.