Solved

SQL Server 2008 R2 - Full Nightly Backup Overwrite

Posted on 2013-02-05
1
977 Views
Last Modified: 2013-02-06
I'm trying to get SQL Server 2008 R2 to perform a full backup of each database on a nightly basis and overwrite the existing backup files in the folder from the previous night.

I have a maintenance plan running and the backup runs each night successfully, but the files are not being overwritten.  My maintenance plan is creating a backup file for every database as it should.

Inside of the maintenance plan dialog, I have the box checked "backup set will expire" and then I selected the radio button "after" with a value of 1 day.

What am I missing so that SQL Server 2008 R2 will overwrite the files?

Thanks
0
Comment
Question by:TacomaVA
1 Comment
 
LVL 7

Accepted Solution

by:
ded_ch earned 500 total points
ID: 38855833
in the Maintenance plan, add a "Maintanance Task" to your backup plan.
It is an option you can drag from the bottom left.

Then configure it to clear all backup files that are older than x days (in your case 1)

Add this Task to the bottom of the plan.
After a sucessful backup, the older files will then be automatically deleted.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

24 Experts available now in Live!

Get 1:1 Help Now