What are the challenges you face when working across database platforms? Take the survey
Options

Backup into sub directories for each DB

tstadlertstadler Posts: 16
edited February 2, 2006 10:36AM in SQL Backup Previous Versions
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

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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>''"
  • Options
    That works, Thank you!
Sign In or Register to comment.