Changing "retention days" for database dumps

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  July 5, 2006 at 1:23 pm

  #112845

  I used the sql 2005 Maintenance Plan Wizard to create a backup plan for a server. Everything is fine. Since that time I need to change the number of backups saved. But I can't find the option under  "Management > Maintenance Plans" or "Sql Server Agent > Jobs" in Management Studio. Where is it hiding out?

  TIA,

   

  Bill

   

   

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  July 5, 2006 at 1:42 pm

  #647611

  Bill,

  In my view Maintenance Plan in 2005 is not a good option right now for prime time use in production environment.

  I have previously placed few issues here

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=241231

  Hope this helps,

   

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com