Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 R2 Cluster in Windows Server 2008 R2 - Maintenance Activity - Start/Stop Services Expand / Collapse
Author
Message
Posted Wednesday, October 2, 2013 5:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:21 PM
Points: 7, Visits: 117
How to Start/Stop SQL Server Services in Two Node Active/Passive Cluster environment?
Post #1500733
Posted Wednesday, October 2, 2013 5:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:21 PM
Points: 7, Visits: 117
Please let me what are all the steps to be taken to successfully complete the task.
Post #1500734
Posted Wednesday, October 2, 2013 5:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:21 PM
Points: 7, Visits: 117
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.
Post #1500738
Posted Wednesday, October 2, 2013 10:30 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:16 PM
Points: 1,538, Visits: 2,587
.. is it SQL Server 2008 cluster ?
I think you can open "cluadmin.msc" and take it offline...
Post #1500848
Posted Friday, October 4, 2013 2:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:21 PM
Points: 7, Visits: 117
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"?
Post #1501463
Posted Friday, October 4, 2013 2:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:21 PM
Points: 7, Visits: 117
Any other changes required Under Nodes or Networks in "Failover Cluster Manager"?. Please let me know. Thanks
Post #1501466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse