June 24, 2009 at 12:48 pm
I have created a maintenance plan that runs a full production backup of my database every day in SSMS 05.
I have have the backup appending to my backup disk. How do I create a second maintenance plan that will clean out this disk by removing databases that are 2 days or older?
It was so much easier in SQL Server 2000, where you just select remove files older than # days.
Thanks
June 24, 2009 at 1:34 pm
It would be much easier if you did not use a single device to contain multiple backups. You should be setting it up to backup to a specific folder instead. This will create a new dated file for every backup.
Then, you can add the Maintenance Cleanup Task to remove old backup files based upon whatever criteria you need.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply