This is the forum to discuss the Wrox book Professional IIS 7 by Ken Schaefer, Jeff Cochran, Scott Forsyth, Rob Baugh, Mike Everest, Dennis Glendenning; ISBN: 9780470097823
Read more about Professional IIS 7 or buy the book from your favorite retailer
You are currently viewing the BOOK: Professional IIS 7 ISBN: 978-0-470-09782-3 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
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.
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.
Restart SQL Server instance on Windows Cluster
Linear Mode
