• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1378
  • Last Modified:

SQL Server 2008 R2 - Full Nightly Backup Overwrite

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
TacomaVA
Asked:
TacomaVA
1 Solution
 
ded_chCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now