SQL Server Performance Forum – Threads Archive

Urgent help

In SQL Server 2005, do we have to restart the server when create the new maintenance plan for system/user databases? Farrukh

No, you don’t need to restart the server or serivices before or after creatintg the maintenance plans…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

hope you have upgraded the box to Sql Server 2005 SP2… if not MP won’t function as expected… Madhu

If it doesn’t work it is better to restart SQLAgent for a fresh start [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

]]>