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

Baking up Multiple DB's to Separate directories.

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!
Jyork
0

Comments

2 comments

Sort by
  • petey
    You could use the database tag as part of the folder name. E.g.
    EXEC master..sqlbackup '-sql "BACKUP DATABASES [*] TO DISK = [G:\Backups\<DATABASE>\<AUTO>] " '

    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.
    petey
    0
  • Jyork
    Perfect- Thanks for the quick response!
    Jyork
    0

Add comment

Please sign in to leave a comment.