Solved

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

Posted on 2013-11-28
1
313 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
ID: 39684343
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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...
OfficeMate Freezes on login or does not load after login credentials are input.
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

685 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