Can maintenance backup job use static filename

  • 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

  • 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.

  • 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

  • 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

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • 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

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply