Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matthew00
Starting Member
10 Posts |
 Posted - 2012-02-14 : 09:22:06
|
| Hi All,I have two questions regarding to Maintenance Plan in specific to History Cleanup Task and Maintenance Cleanup Task.1. Maintenance Cleanup task: I want to clean up all of the backup files that are old than 2 weeks so I used Maintenance Cleanup Task to do so, the question is I have sub folders for every DB, for example: E:\BACKUP\DUMMY1_DOMAIN_COM\DUMMY.BAK (DUMMY1 IS THE NAME OF MY DB). In the Maintenance Cleanup Task, it had "search folder and delete files based on the extension", so I put "E:\BACKUP" and file extention, I had "BAK" and "check" on Include the fist level subfolder. it doesn't seem to work since I didn't point to the specific folder for each database, I used "E:\BACKUP" and SQL only looked for .BAK under backup folder and of course it won't find those files. Thoughts?2. History Clean up: does it only delete the metadata within msdb for backup and restore history , etc..... do I get any benefit to have history clean up as well? 3. Is it required to have History Cleanup Task to be run first before I run Maintenace Cleanup Task?thanks all |
|
|
|
|
|
Maintenance Plan:History &Maintenance Cleanup Task