how do i make it delete the old backups when using database main. wizard?

• adam spencer

  Hall of Fame

  Points: 3926

  More actions

  November 16, 2005 at 4:25 pm

  #110378

  when i am using standard edition and use database maintanence wizard to schedule my backups , when it backs up it delets the old back up file ,but when i schedule it for my msde edition it does not delete the old back up file so i have to do it manually, how can i fix this?

  thanks

• November 21, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  November 23, 2005 at 12:33 pm

  #605533

   

  Instead of using maintenance plan, create a Backup device and also a job

  for backup. This way you always having one physical file whose logical name

  is your backup device name.

   

  Kindest Regards,

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