Post reply

Backup maintenance plan filename

  • May 14, 2008 at 3:40 am

    #207320

    Hi,

    I added a full backup task to the maintenance plan of our new SQL Server.

    It's setup to do all user databases and to create a backup file and a separate subdirectory for each database.

    This is just the way i want it except for the part that each filename has the datetime stamp. Is there some way to disable this? So i only have .Bak?

    The reason i need this is because we upload these backups with a online backup utility but there is no option there to remove certain files.

    Thanks!!

  • May 14, 2008 at 7:02 am

    #815136

    You can use an Execute T-SQL Task in your maintenance plan and script the backup exactly as you want it.

  • May 14, 2008 at 7:41 am

    #815181

    Hi

    The online backup utility you use, you mentioned that you can not remove certain files.

    Do you mean there are files in your backup folder other than those with the .BAK ?

    If you want to only upload say the last 2 days of backups then part of your maintenance plan - maybe you could remove older files.

    As mentioned above - you could instead - "grab" the script from a normal backup and ensure that the name of the backup file is what you want and also ensure that you overwrite the existing backup and not to append.

    Then take this script and add it as a job step in a schedule.

    Let us know more info

    Thanks

    Kevin

  • May 14, 2008 at 8:06 am

    #815221

    Hi,

    I modified our backup so we use only 1 Bak file for all user databases.

    The problem with the online backup utility is that once i uploaded a certain file, it will remain in the backup session. Therefor deleting files older then 2 days on the sql-server (which we already do) isn't enough. Those older file stay on the online backup device and so we would get more and more files up there.

    Now with only 1 Bak file that isn't a problem anymore.

    Thanks for the help!!

  • May 14, 2008 at 9:25 am

    #815301

    ok I understand a bit more about the backup device limitations.

    Great - good to hear that all is sorted

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

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