Announcement Banner
UNSOLVED

zhaos2

updated

15 years ago

Z

zhaos2

2 Intern

•

643 Posts

0

1230

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!

  • 522

    1

    Posted 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

    522

    1

    Posted 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

    522

    0

    Posted 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?