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

Backup into sub directories for each DB

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
tstadler
0

Comments

2 comments

Sort by
  • 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>''"
    Brian Donahue
    0
  • tstadler
    That works, Thank you!
    tstadler
    0

Add comment

Please sign in to leave a comment.