Solved

How To Configure Database Maintenance Plan to only Backup Last 7 days on SQL 2012

Posted on 2013-11-28
1
309 Views
Last Modified: 2016-02-11
Basically, as the title says, I want to configure my plan to only backup the database every night for the last 7 nights.  anything older than that should be deleted away.

The reason why is space.  The space on my HD is being eaten away rapidly.

Am I going to have to create a custom SSIS package or is there some way to configure the maintenance plan to do it?  Gotta believe there is and that Microsoft, even though often befuddling in their choices, has given me that option.

Thanks
0
Comment
Question by:cat4larry
1 Comment
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
Comment Utility
Under the maintenance task there should be a "Maintenance Cleanup Task" that you can add to the plan to allow you to delete files based on age.

Further info: http://technet.microsoft.com/en-us/library/ms177182.aspx
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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...
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

772 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

10 Experts available now in Live!

Get 1:1 Help Now