Solved

SQL Server 20008 R2 Backup plan will not delete my old backups

Posted on 2013-05-17
3
1,017 Views
Last Modified: 2013-05-20
SQL Server 2008 R2 (64 bit) running on Windows Server 2008 R2.

I have a Maintenance Plan that I created with the wizard.  It simply does a Full backup each night.  I have the "Backup set will expire" set to "After 1 days".  Everything else is the default (disk folder and bak extension).  The backup files are not automatically deleting each night.

This worked fine in Win 2003/SQL 2000 so I'm guessing it is some crazy "over the top" security measures that have been added to Windows/SQL 2008.  (Wish I could turn it off as I'm not concerned with security - only myself and my coworker get on this server.)

I have added the "SQLServerSQLAgentUser$usernameMSSQLSERVER" Group to the 'Backup' folder and it has full permissions.

I'm not a security expert or Pro DBA (main job is developer) so I guess I'm going to need some step-by-step advice to fix this.

Thanks
SQLbak.jpg
0
Comment
Question by:sqdperu
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 39174489
you have to add another step (maintenance plan wizard: Maintenance Cleanup Task)
0
 

Author Comment

by:sqdperu
ID: 39174739
After doing further reading, it appears the "Backup set will expire" is only to protect the file and does not do the delete.  (I was thinking that is what caused the delete to happen.)
I added a cleanup task to my existing backup plan using the settings found here:

Steps to add cleanup task to existing backup plan

I will see how if it worked when I come back on Monday and report back.

Thanks.
0
 

Author Comment

by:sqdperu
ID: 39180724
That worked.

Thanks.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A procedure for exporting installed hotfix details of remote computers using powershell
I have a large data set and a SSIS package. How can I load this file in multi threading?
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question