Help creating backup jobs

MasterCephus

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?

Ben Pinchen

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

MasterCephus

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:

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

???

Matthew Flatt

Hi,

You would specify the folder/filename as follows :

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

Thanks,