SQL Server Performance

SQL Server Maintenance Plan

Discussion in 'SQL Server 2008 General DBA Questions' started by cjzimm, Dec 21, 2010.

  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
  2. satya Moderator

  3. Luis Martin Moderator

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

Share This Page