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
 General SQL Server Forums
 New to SQL Server Administration
 Safe shutdown in case of power outage

Author  Topic 

mayoorsubbu
Yak Posting Veteran

95 Posts

Posted - 2015-04-30 : 22:00:40
Hi Friends,
I have my database running on SQL Server 2000 in a clustered environment. Is there any way to execute a safe shutdown in case my UPS battery level reaches a critical level?
Thanks

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-05-01 : 01:32:37
Safe shutdown normally includes shutting down the application(s) connected to the SQL Server. Transactions are either commited or rolled back.
This is a typical situation in patching, whereby a procedure is set up - normally scripted - which shuts down everything in a certain order.
And also starts up in a certain order

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -