Post reply

Maint plan backup options

  • October 19, 2010 at 8:10 am

    #225286

    Hello

    question related to the maint plan for full backup in 08r2.

    Basically in sql 2000 when I created a maint plan for a full backup, I was able to opt for 'delete (backup) files older than x days/weeks'

    I just looked at all properties/settings in my new maint plan and the agent job props etc

    can't find where to specify the same.

    Can someone tell me where it's done?

    we have been keeping 5 days and would like to continue doing same

    thanks

  • October 19, 2010 at 9:00 am

    #1239094

    Its a separate task from the pane on the left. 'Maintenance cleanup task'

    drag this over, set up to delete bak files, and put a dependency on the backup task.

    ---------------------------------------------------------------------

  • October 19, 2010 at 9:26 am

    #1239126

    thanks very much.

    I've never dealt with dependencies before.

    What should the old .bak/log deletion depend on?

  • October 19, 2010 at 9:58 am

    #1239156

    you will have two tasks in your maintenance plan window. Connect them together with a 'on success' flow arrow. i.e. just drag the arrow emanating from the backup task to connect to the cleanup task.

    In the cleanup task for file type to delete make sure you specify bak and not .bak

    ---------------------------------------------------------------------

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

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