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

Help creating backup jobs

MasterCephusMasterCephus Posts: 35
edited September 30, 2008 8:10AM in SQL Backup Previous Versions
I need help creating backup jobs.

I am trying to create a weekly full backup job of all our user DBs. What I would like to do is create folders named by date. So I would run a full backup tonight, it would put the entire backup in a folder name '09-26-2008' and then I could push that to my network share. Then tomorrow if I ran a backup, it would put the entire backup in a folder named '09-27-2008' and push that folder to the network.

This way I can keep up with my backups based on days easily for me.

Does anyone know (if possible) how to accomplish this?

Comments

  • Options
    I think that the following document should help answer your question -
    http://www.red-gate.com/supportcenter/C ... onTags.htm

    You can add tags to your backup location to add a datetime stamp. For example if you want your backups to go to separate folders based on datetime you can make the path similar to the following:

    C:\Backups\<DATETIME yyyymmdd>\<database>.sqb

    This would save your full backups in a folder named the date that they were created and the backup file would be named the same as the database backed up e.g.

    C;\Backups\20080929\Adventureworks.sqb
  • Options
    Looking at the GUI, I see a Backup Folder location textbox and a File name format textbox.

    Do I make this change at the file name format and name it like you said:

    <Type>\<DATETIME mm-dd-yyyy>\<DATABASE>

    or do I do it at the Backup Folder location:

    D:\Backup\<TYPE>\<DATETIME mm-dd-yyyy>
    then have the file name format as:
    <DATABASE>

    ???
  • Options
    Hi,

    You would specify the folder/filename as follows :

    D:\Backup\<TYPE>\<DATETIME mm-dd-yyyy>
    then have the file name format as:
    <DATABASE>

    Thanks,
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.