Setting up a maintenance plan in SQL 2005, I do not see the same option that was in SQL 2000, to indicate the amount of days to keep the backup. Backing up once a day, and there just accumulating. How can I change the maintenance plane to delete backups older than 3 days?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Maintenance Plan 1
- Thread starter ThomH
- Start date
-
1
- #2
macleod1021
Programmer
Thom,
I had the same question a couple weeks ago when I setup a new maintenance plan. I don't remember where I found it at, but the answer is to go into the maintenance plan (right click...modify) then add a Maintenance Clean Up Task. Then edit the task...give it the location of your backups and the extension. Then set how old to keep. Then save the plan.
I had the same question a couple weeks ago when I setup a new maintenance plan. I don't remember where I found it at, but the answer is to go into the maintenance plan (right click...modify) then add a Maintenance Clean Up Task. Then edit the task...give it the location of your backups and the extension. Then set how old to keep. Then save the plan.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
