SQL Server 2008 R2 Cluster in Windows Server 2008 R2 - Maintenance Activity - Start/Stop Services

  • How to Start/Stop SQL Server Services in Two Node Active/Passive Cluster environment?

  • Please let me what are all the steps to be taken to successfully complete the task.

  • Maintenance activity involves to stop both the nodes (Two Node - Active/Passive) in the cluster environment. Please advice on Step by Step process of Stopping and Restarting SQL Server Services. I mean to make Cluster environment as it was.

  • .. is it SQL Server 2008 cluster ?

    I think you can open "cluadmin.msc" and take it offline...

  • Yes. It is SQL Server 2008 R2 Cluster. If we make Services under "Services and Applications" offline, Will that enough?

    After maintenance activity, Do I need to work on anything else apart from making Services Online under "Services and Applications"?

  • Any other changes required Under Nodes or Networks in "Failover Cluster Manager"?. Please let me know. Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply