Ask a questionAsk a question
 

AnswerMaintenance Plan Info SQL Server 2005

  • Wednesday, November 04, 2009 9:48 AMDaniele82 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hello Everybody,
    today I've designed Maintenance Plan for System Center Operation Manager Databases: I've created four single Full Backup Task scheduled at different hours for each Databases (OperationManager, OpsMgrDW, ReportServer, OperationManagerACS) with option "Create a Sub Directory for each Database";
    I've also attached in first backup task (OperationManager) a Maintenance Cleanup Task, to delete old backup files (1 day) and I've selected option "Include first level Subfolders"
    Now I've a doubt: I Must design a Maintenance Cleanup Task for each scheduled Backup Task, or the first Maintenance Cleanup works fine for all Databases Backup Tasks?

    Thanks a lot everybody

Answers

  • Wednesday, November 04, 2009 10:01 AMLekss Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Supposing if you are taking backup in to E:\backup (for three databases) , create sub director for each database creates three new folders like
    E:\backup\a
    E:\backup\b
    E:\backup\c
     
    If your maint clean up plan was to search E:\backup on the box search folder and delete files based on an extension and now if include first level sub folders are selected , then there is no requirement for other separate maint clean up task . Else , if the folder in which it is going to search is E:\backup\a , then you need to include maint clean up tasks separately.

    Thanks, Leks

All Replies

  • Wednesday, November 04, 2009 10:01 AMLekss Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Supposing if you are taking backup in to E:\backup (for three databases) , create sub director for each database creates three new folders like
    E:\backup\a
    E:\backup\b
    E:\backup\c
     
    If your maint clean up plan was to search E:\backup on the box search folder and delete files based on an extension and now if include first level sub folders are selected , then there is no requirement for other separate maint clean up task . Else , if the folder in which it is going to search is E:\backup\a , then you need to include maint clean up tasks separately.

    Thanks, Leks
  • Wednesday, November 04, 2009 10:18 AMDaniele82 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Ok,
    Thank you very much for explanation!!!

    ;)