1. cjzimm New Member

   I am trying to create a maintenace plan that will create a full database backup once a week, simple enough I know. But I can't quite get it so that it will keep 3 weeks worth of backups going forward. Each week I want the new backup to be created and the older backup (3 weeks old) to be deleted. Can someone please help me with this?
   CJ
   

   cjzimm, Dec 21, 2010

   #2
2. satya Moderator

   Within that plan using the Maintenance Cleanup Task you can remove old files related to maintenance plans, including text reports created by maintenance plans and database backup files. See http://msdn.microsoft.com/en-us/library/ms189036(v=SQL.100).aspx for more information.
   

   satya, Dec 22, 2010

   #3
3. Luis Martin Moderator

   Welcome to the forums.
   Also you can find information in BOL.
   

   Luis Martin, Dec 22, 2010

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in