Solved

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

Posted on 2013-05-17
3
977 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
A procedure for exporting installed hotfix details of remote computers using powershell
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now