p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional IIS 7 ISBN: 978-0-470-09782-3 (http://p2p.wrox.com/forumdisplay.php?f=391)
-   -   Restart SQL Server instance on Windows Cluster (http://p2p.wrox.com/showthread.php?t=88092)

katty.jonh July 25th, 2012 04:07 AM

Restart SQL Server instance on Windows Cluster
 
Hi All,

We have a active-passive Windows cluster environment, built on Windows 2003 Enterprise edition. On this cluster, there are 6 SQL 2005 instances residing.

Now, I need to restart one of this SQL instances. I would like to know what is the best way around to restart the SQL instance on this windows cluster environment.

Regards,
Shovan

nimolccd July 25th, 2012 04:10 AM

Re: Restart SQL Server instance on Windows Cluster Reply to Thread
 
Shovan

Go into Cluster Administrator, take the SQL Server resource for the instance in question offline, then bring it back online. Don't forget to ensure that SQL Server Agent starts too. You can do a similar thing in SQL Server Configuration Manager if you prefer.

Nimol
Programmer
Corbin Creative Databases, LLC
http://corbincreative.com


All times are GMT -4. The time now is 05:52 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.