Solved

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

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

821 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