InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:27:33 GMT20http://www.sqlservercentral.com/Forums/Topic1190971-2905-1.aspx[quote][b]runaldo (2/15/2012)[/b][hr]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.[/quote]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.Wed, 15 Feb 2012 07:51:06 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic1190971-2905-1.aspxSelecting "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. DavidWed, 15 Feb 2012 07:21:11 GMTDavidSimpsonhttp://www.sqlservercentral.com/Forums/Topic1190971-2905-1.aspxcheck 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.Wed, 15 Feb 2012 03:20:27 GMTrunaldohttp://www.sqlservercentral.com/Forums/Topic1190971-2905-1.aspxok,good,very good.Wed, 15 Feb 2012 02:08:07 GMT1739207884http://www.sqlservercentral.com/Forums/Topic1190971-2905-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72462/">Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs</A>[/B]Sat, 15 Oct 2011 15:07:15 GMTRichard Waymire