Unsolved
This post is more than 5 years old
2 Intern
•
643 Posts
0
1114
March 8th, 2012 00:00
SQL Server Instance Failover
If I have a SQL server cluster environment: 2 nodes SQL Server 2008, Node A & Node B, there are multiple instances on each node, for example 5 instances on Node A. My question is can I manually failover only one instance from Node A to Node B? What are steps?
Thanks in advance!
No Events found!
Michael_Morris
18 Posts
1
March 8th, 2012 01:00
Failover is at instance level, you can initiate failover manually through the GUI's or through powershell etc as normal practice for a single instance, just choose the instance you want to failover.
Some info below from our new WP EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012
https://community.emc.com/docs/DOC-14614
Table 1 Comparing FCI nodes and availability group replicas
Uses WSFC cluster
Yes
Yes
Storage type
Shared
Non-shared
Performs a failover of storage
Yes
No
Protection level
Instance
Database
Number of nodes/replicas
Standard: 2
5 (including primary)
Enterprise and Datacenter: 16
Readable secondary copies
No
Yes
Applicable failover policy settings
WSFC quorum
WSFC quorum
FCI-specific
Availability group settings
Availability group settings
Failed over resources
Server, instance, and database
Database only
JamesBEMC
257 Posts
1
March 8th, 2012 02:00
Exactly
For each SQL Server Instance, a virtual Instance will be created (MSSQLSERVER1, MSSQLSERVER2, etc)
Each SQL Server Virtual Instance will have its own installation of binaries and also Cluster Group
Each Cluster Group will have its own resource dependancies (Net name, IP, Storage, SQL Instance (SQL Service)
You would perform a Move-Group (Move this service or application to another node).
It is vitally important that there are no underlying dependancies across SQL Cluster Groups, which in the event of say SQL #1 Group failing over to Node B, that it could affect any other of the 2-5 Cluster Groups.
An example of this is an underlying disk resource used by both cluster groups (but cluster resource logic should prevent this from being configured)
zhaos2
2 Intern
•
643 Posts
0
March 8th, 2012 21:00
Thanks James & Michael for your helpful answers!
Could I also have your advise on the SQL server storage sizing in SQL cluster environment? Any best practice consideration or recommendation?