OS shutdown.

When shutting down or restarting the OS, should I shut down ms-sql 2000 first
I can't find this documented anywhere.
I've always done the following
Shut down applications or services useing the database
Shut down SQL-200
Shut down OS.
Is this the perfered method? and is it documented somewhere?It is not necessary to shut down SQL separately. Shutting down the OS
normally will cause a normal service shutdown.
SQL is designed to recover correctly after a service/system shutdown and
restart. Transactions in progress will be either rolled back or forward
depending on whether the transaction was committed in the log before the
shutdown.
Look up 'Stopping SQL Server' in BOL for exactly what happens during a
service shutdown.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:1FC0335A-1F8E-4F88-B228-6ABD7608AC7C@.microsoft.com...
> When shutting down or restarting the OS, should I shut down ms-sql 2000
first?
> I can't find this documented anywhere.
> I've always done the following:
> Shut down applications or services useing the databases
> Shut down SQL-2000
> Shut down OS.
> Is this the perfered method? and is it documented somewhere?|||In addition to Geoff's answer, although most folks do NOT shut down SQL
separately, there is a slight difference ...
when you shut down SQL by bringing the OS down, stopping the service, or
using net stop service, SQL comes down now and hard...
IF you shut down SQL Server from SEM or the SQL Server service manager, it
prevents any new logins, or new transactions, waits until current
transactions are complete, then brings the server down...
SQL will recover properly in either case.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:1FC0335A-1F8E-4F88-B228-6ABD7608AC7C@.microsoft.com...
> When shutting down or restarting the OS, should I shut down ms-sql 2000
first?
> I can't find this documented anywhere.
> I've always done the following:
> Shut down applications or services useing the databases
> Shut down SQL-2000
> Shut down OS.
> Is this the perfered method? and is it documented somewhere?