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.


nimolccd July 25th, 2012 04:10 AM

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

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.

Corbin Creative Databases, LLC

All times are GMT -4. The time now is 03:22 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.