Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Waymire Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs RE: Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs

  • February 15, 2012 at 7:51 am

    #1447325

    runaldo (2/15/2012)

    check out ola.hallengren.com

    Problem with this maintenance solution is that it doesn't take backup of new databases. You manually need to add it to the job. Hallengren's solution fixes all these problems.

    Ola's stuff addresses a HUGE range of flaws and shortcomings with the SQL Server Maintenance Plans! I recommend it to every one of my clients whether they be mom-and-pop or Fortune 500.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service