Post reply

Maintanance Plan

  • February 23, 2009 at 1:22 am

    #200202

    I've created a maintenance plan to backup a few databases. All appears working

    well except that each backup appends to the existing file rather than overwiting it.

    I setup the backup plan with the wizard a couple of times, but I do not see

    any option that says overwriting.

    I thought I would just adjust the script that is created, but I couldn't find any related statement in that!

    (I'm having SP1 installed on the server)

    Could anyone tell me how to change the properties of the maintenance plan to overwrite the existing file or create another file, each time that it backs up?

  • February 23, 2009 at 2:11 am

    #948471

    You need to add "Maintenance Cleanup Task" with desire retention period of Database Bakup.

    HTH

    Cheers

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • February 23, 2009 at 2:43 am

    #948479

    Thanks for the reply 🙂

    Does it mean that there's no way to set such properties in the maintenance plan?

  • February 23, 2009 at 7:53 am

    #948600

    When creating a Maintenance Plan choose "Create a backup file for every database" in the "Back Up Database Task" dialog.

    Now SQL Server is adding a timestamp to your backup file.

    Append is only an option when you choose "Back up databases across one or more files"

  • February 23, 2009 at 8:22 am

    #948627

    (I'm having SP1 installed on the server)

    FYI, SP3 was released recently.

  • February 24, 2009 at 8:06 am

    #949395

    You will definitely need to add, at the minimum, SP1 to the SQL Server. It had a very important fix regarding maintenance plans.

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

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