db maintenance documention

Question

I am trying to create a SQL 2005 db maintenance tasks document. Can anyone provide me inputs/ouputs and/or basic template. I will appreciate it.

Answer 1

Have a look at PAUL.S.RANDAL's technet article,

http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx?pr=blog . You will have to read this document and decide the maint plans that are essential in your environment and we cant help you with exact DOCS.

---

Thanks, Leks

Answer 2

Here is a video about Database Manitenance Optimiztion:
http://sqlbits.com/Agenda/event4/Database_Maintenance_Optimization/default.aspx

Hope this helps, thanks.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 3

Thanks Lekss. Its really helps... :-)