Baking up Multiple DB's to Separate directories.
Jyork
Posts: 4 Bronze 2
Hi-
I was wondering if there was an easy way (outside of separate jobs) to create a backup of databases each to their own directories within a location. An example of this is already present in Enterprise Manager's Database Maintenance Plan Wizard. You can chose multiple db's to back up in a specific location, each with their own sub-directory. Is this possible to accomplish via the GUI(didn't see it there) or by editing the script that is created in the SQL Agent job? Any help is appreciated. Thanks!
I was wondering if there was an easy way (outside of separate jobs) to create a backup of databases each to their own directories within a location. An example of this is already present in Enterprise Manager's Database Maintenance Plan Wizard. You can chose multiple db's to back up in a specific location, each with their own sub-directory. Is this possible to accomplish via the GUI(didn't see it there) or by editing the script that is created in the SQL Agent job? Any help is appreciated. Thanks!
Comments
The option to do this via the GUI isn't available. The workaround is to add the tag as part of the 'Backup folder' value in Step 3 of the Schedule Backup wizard.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8