SHUTDOWN is in progress in Production DB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SHUTDOWN is in progress in Production DB

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2008-12-12 : 11:16:07

Hi All

We see the following message in our application logs on production.
SHUTDOWN is in progress. [See nested exception: com.inet.tds.at: Msg 6005, Level 14, State 1, Line 1, Sqlstate 01000

It happened twice in the last 3 days. Can you please suggest any scripts or monitors to setup to know the cause the SQL server restart

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-12 : 11:20:23

Have you applied Latest Service packs on SQL Server?

venkath
Posting Yak Master

202 Posts

Posted - 2008-12-12 : 11:33:21

The current version of SQL Server 2005 on production is

SQLServer 9.00.3233.00-SP2(Enterprise Edition (64-bit))

Do we have any known bugs of this kind for this version?

Thanks

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-12-12 : 11:54:14

To set alert go to services in control panel\administration tools and on SQL Server service set on fail action = run program.

Create a batch or vbs file to contact you either using net send, or send an email (http://www.visualbasicscript.com/m_64889/mpage_1/key_/tm.htm#64889)

Call this program on service failure.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources