August 4, 2003 at 10:51 am
I need to backup to the same filename each night because of tape backup software that will then pick up the backup afterwards in its job. Can I modify a maintenance wizard backup job or should I script its equivalent. If scripting is the answer is there a way to find out the script equivalent to the different options I'm choosing in a maintenance wizard backup?
Thanks,
Doug
August 4, 2003 at 11:30 am
I don't think that you can specify the backup filename when using a maintenance plan, what you could do is right click on the database and select all tasks|backup database from the popup, or you could script out the backup, just look backup up in BOL.
Otherwise, couldn't you setup your tape backup to backup the directory where you are storing your backups?
jimmY
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
August 4, 2003 at 2:24 pm
Along the lines of what jimmY is saying you could set up your maintenance plan to backup to a directory and keep only the last however many days you want.
Then setup your backup software to grab that whole directory.
This solution will be a lot more flexible in the long run.
Ross
August 4, 2003 at 4:15 pm
agree with both above.
You could add a task to rename the file, but I've found over time that having the timestamp in the name is very handy.
Steve Jones
August 4, 2003 at 4:33 pm
I agree having the timestamp is worth something. Same reason I don't use devices for backup. I'd rather backup an entire folder than a specific file, that way when I add a backup it gets included automatically.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply