[dba-SQLServer] Windows shutdown

Well I have discovered that shutting down two SQL Server services before
shutdown appears to prevent the hang at reboot so there ya are.  I built a
cmd batch file to do the service shutdown and then a reboot and all appears
to be well.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Sunday, July 29, 2007 10:51 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Windows shutdown

Well, you win the WAG award!  I found something somewhere that says to
prevent hanging, shut down all application services before shutting down the
server. I will give that a try and see what happens.


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Webadmin -
Tenbus
Sent: Sunday, July 29, 2007 2:46 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Windows shutdown

Sorry - I did not express that very well!

What I was trying to suggest is that (probably correctly for a server) the
OS will not shut down if the SQL Server is still running and
(possibly) serving data.

I think you need to stop the SQL Server before you shut down the OS. I'm not
a server guy, and it is Sunday morning in England but that's what I'd look
at in your situation.

Regards!
Chris Foote