Post reply

DB Mirroring with Clustering

  • May 4, 2012 at 8:58 am

    #255444

    Hi....

    For my Learing purpose. i am trying to implement DB mirroing in SQL server 2 node clustring in Test Environment.

    Cluster Name : CLU1

    NODE Name1: N1

    NODE Name2:N2

    DBName :PrincipalDB

    When i am tring to implement mirroring N1 and N2 for db

    PrincipalDB. I am getting following error

    This SQL Server message indicates that the server network address cannot be reached or does not exist Error Message 1418

    Where as When i am trying to implent DB mirring between two different clusters it was getting success

    Ex:

    Cluster Name:CLu2

    Node Name :N3

    Node Name :N4

    Mirroing is working fine between N1 and N3.

    1) I wants to know what went wrong mirring with N2.

  • May 4, 2012 at 9:18 am

    #1483642

    Without seeing the DDL you are trying to use to create the mirror between N1 and N2 we can only guess.

    Are you trying to create this mirror to a different instance on N2?

  • May 6, 2012 at 2:54 pm

    #1483927

    Simha24 (5/4/2012)

    Cluster Name : CLU1

    NODE Name1: N1

    NODE Name2:N2

    DBName :PrincipalDB

    When i am tring to implement mirroring N1 and N2 for db

    PrincipalDB.

    You can't create a mirror between 2 nodes in the same cluster. The mirror is created against the virtual network name for the clustered SQL server instance. Read up firstly on how a fail over cluster works then thoroughly read up on database mirroring.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 7, 2012 at 12:29 am

    #1483962

    I am Trying to create mirroring on different instance in Node N2 But it useses same Virtual Name

  • May 7, 2012 at 12:55 am

    #1483969

    Finaly i understood that mirroring in failover clustering will possible between two clusters.

    Reference doc:

    http://technet.microsoft.com/en-us/library/ms191309(v=sql.90).aspx

  • May 7, 2012 at 1:21 am

    #1483982

    Simha24 (5/7/2012)

    I am Trying to create mirroring on different instance in Node N2 But it useses same Virtual Name

    Forget the node names, for the most part in a cluster they become irrelevant. The instance virtual network names are the entry points used.

    For instance I have 2 clusters

    Cluster Winclust001

    Nodes Node A, Node B

    SQL inst Sqlclust001\inst1

    Cluster WinclustDr001

    Nodes Drnode A, Drnode B

    SQL inst Sqlclustdr001\inst1

    I am creating a mirror session from SQL inst to SQL inst not from node to node, they are meaningless in this context.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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