Is it really needed to STOP SQL Service before reboot the ..

My 2 cents. I ALWAYS stop SQL myself prior to a reboot after having a
DB come up suspect on me once.

Look for any running jobs. If they are critical, wait till it is
finished, otherwise kill all active jobs in SQL Agent before stopping
SQL Agent.
The I stop the SQL Server Servce. This will stop any new transactions
from processing, and allow any that are in flux to complete and flush
to disk. This will save time on a restart as it won't need to replay
the transaction log when it brings the databases up.

Good luck!

David Hay
 >> Stay informed about: Is it really needed to STOP SQL Service before reboot the .. 

Linchi
I have seen many times when people rebooted a server without stopping SQL
Server and the databases come up in suspected mode.
I used to stop SQL Server services before rebooting the server







"Linchi Shea" wrote in message

> No, you don't need to stop SQL service before rebooting a server. SQL
> Server
> is built to handle a server crash. A reboot is actually much cleaner than
> a
> real crash.
>
> But i'm still seeing people religiously rebooting their Windows servers
> once
> every week to starve away any potential instability. If that makes people
> feel better, I guess that's what they need to do.
>
> Linchi
>
> "Carlos Felipe Fran?a da Fonseca" wrote:
>
>> Is it really needed to STOP SQL Service before reboot the server?
>>
>> Based on the the value in the registry key
>> HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout, the
>> server
>> can kill the process if it takes too long to stop. I think it's not a
>> good,
>> right?
>>
>> Thx,
>>
>> Felipe
>>
>>
>>
 >> Stay informed about: Is it really needed to STOP SQL Service before reboot the .. 

Uri


What I would suggest before rebooting the server or sql server service is,
DBA must ensure that ; no user/application connection to sql server is
present. A nice clean shutdown (thats what Microsoft call it)
My procedure is
1. stop sql agent service
2. disconnect all users/application connection
3. stop the sql server service

vinu




"Uri Dimant" wrote in message

> Linchi
> I have seen many times when people rebooted a server without stopping SQL
> Server and the databases come up in suspected mode.
> I used to stop SQL Server services before rebooting the server
>
>
>
>
>
>
>
> "Linchi Shea" wrote in message
>
>> No, you don't need to stop SQL service before rebooting a server. SQL
>> Server
>> is built to handle a server crash. A reboot is actually much cleaner than
>> a
>> real crash.
>>
>> But i'm still seeing people religiously rebooting their Windows servers
>> once
>> every week to starve away any potential instability. If that makes people
>> feel better, I guess that's what they need to do.
>>
>> Linchi
>>
>> "Carlos Felipe Fran?a da Fonseca" wrote:
>>
>>> Is it really needed to STOP SQL Service before reboot the server?
>>>
>>> Based on the the value in the registry key
>>> HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout, the
>>> server
>>> can kill the process if it takes too long to stop. I think it's not a
>>> good,
>>> right?
>>>
>>> Thx,
>>>
>>> Felipe
>>>
>>>
>>>
>
>
 >> Stay informed about: Is it really needed to STOP SQL Service before reboot the ..