Re: [Emerald] Re: HElp

Dale E. Reed Jr. ( (no email) )
Fri, 04 Jun 1999 11:26:10 -0500

Darin Spence wrote:
> So before rebooting an SQL server, one should stop the service, then reboot?

Under heavy load, SQL Server may not be able to orderly shut down in
time before NT says "Die, you, DIE!". In that case, your database will
be in a recovery mode when you restart SQL Server. If you manually
stop SQL Server before rebooting (and wait for it to stop), then you
are guranteed an orderly shutdown and can avoid the recovery issue.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.