Backup into sub directories for each DB
tstadler
Posts: 16
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
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
Comments
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>''"