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.
| 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 orderJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Safe shutdown in case of power outage