SQL Server Maintenance Plans

Hi,
I know some use of Maintenance Plans.
I am looking for a great blog links else an eBook which will detail a professional level use of SQL Server Maintenance Plans?

Thanks
crazywolf2010Asked:
Who is Participating?
 
David ToddSenior DBACommented:
Hi,

I agree with AC.

For instance, with SQL 2000, when doing a week-day backup, you had to specify keeping 72hours worth of backup to keep Friday nights backup till Tuesday ...

So I wrote my own procedure that kept n backup files as well as h hours worth.

However, Brad McGehee has written a book that is a free pdf
http://www.simple-talk.com/books/sql-books/brads-sure-guide-to-sql-server-maintenance-plans/

HTH
  David

PS I've found with the older sql 2000 maintenance plans that when they go wrong the only cure is to delete them and recreate from scratch. However, the new SQL 2005 and upwards plans are in fact SSIS packages, which seem a little more resiliant. And I've graduated to rolling my own via procedures so to speak.
0
 
Anthony PerkinsCommented:
>>detail a professional level use of SQL Server Maintenance Plans?<<
I am going to go out on a limb here and state that most professionals do not use SQL Server Maintenance Plans.  They are buggy, limiting and in general a PITA.  Nothing that cannot be accomplished with T-SQL.
0
 
David ToddSenior DBACommented:
Hi,

Check out this question:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27522726.html

The link is interesting ...

Regards
  David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.