Configure number of days to keep the backups in SQL 2005 maintenance plans

• Roust_m

  SSCoach

  Points: 17410

  More actions

  January 17, 2007 at 10:13 pm

  #171052

  Hi,

  I tried to create some backup maintenance plans in SQL 2005, but could not find the option.  Was it removed from SQL 2005?

  Thanks.

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 17, 2007 at 10:25 pm

  #683905

  No it is not removed. What edition are you using? If you are using SQL Express, I think it is not there...

  In other editions...

  SQL management studion/Management/MaintenancePlans

  http://msdn2.microsoft.com/en-US/library/ms189036.aspx

   

   

  MohammedU
  Microsoft SQL Server MVP

• Roust_m

  SSCoach

  Points: 17410

  More actions

  January 17, 2007 at 10:59 pm

  #683906

  I found this out.  You need to manually add "Maintenance cleanup task" to have the old backups deleted.  You can not do it in the DMP wizard.

  I am using standard edition.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  January 18, 2007 at 5:21 am

  #683965

  specifying the retention period is available with 2005. There have been few may chages to the Mp wizard in sql 2005.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com