Solved

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

Posted on 2013-05-17
3
1,001 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

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Question has a verified solution.

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

Suggested Solutions

OfficeMate Freezes on login or does not load after login credentials are input.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

910 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

22 Experts available now in Live!

Get 1:1 Help Now