Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Richard Waymire » Stairway to SQL Server Agent - Level 11:...

Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Waymire

Posted Saturday, October 15, 2011 3:07 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

Comments posted to this topic are about the item Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs

Post #1190971

1739207884

Posted Wednesday, February 15, 2012 2:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 2:01 AM
Points: 2, Visits: 9

ok,good,very good.

Post #1252307

runaldo

Posted Wednesday, February 15, 2012 3:20 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 5:23 AM
Points: 74, Visits: 435

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.

Post #1252359

DavidSimpson

Posted Wednesday, February 15, 2012 7:21 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 890, Visits: 932

Selecting "All Databases" or "All user databases" will backup any new databases automatically. I also recommend Hallengren's solutions but I just use the index maintenance. I feel that backups and integrity checks are very easily managed by maintenance plans... although to be fair I've not compared all the options of Hallengren's backup and integrity solutions to those in the maintenance plans.

David

Post #1252463

TheSQLGuru

Posted Wednesday, February 15, 2012 7:51 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 6:58 PM
Points: 3,581, Visits: 5,125

runaldo (2/15/2012)

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 at GMail

Post #1252479

« Prev Topic | Next Topic »

Permissions