Backup into sub directories for each DB

tstadler

Hello,
I have to say what a great tool! We are in the proccess of reworking our maint plans and one thing I can't seem to locate is this, within a standard maint plan I can create sub directories for each db backup the switch is (-CrBkSubDir) I haven't found this in the documentation for 4.x SQL Backup. I could create a new job set for each DB to place in the correct dir but that would take awhile, any help would be great.
Thanks

Brian Donahue

Hello,

This is certainly possible by modifying one of the jobs created with SQL Backup 4's new schedule wizard. In the part of the job script that specifies the backup file name, you can use the tag <database> to substitute the database name. For instance:
master..sqlbackup '-SQL "BACKUP DATABASE [Northwind] TO DISK=''c:\backups\<DATABASE>\<Auto>''"

tstadler

That works, Thank you!