6 Steps to setting up Replication with Mirroring

  • ImYourDBA

    SSCertifiable

    Points: 5654

    Comments posted to this topic are about the item 6 Steps to setting up Replication with Mirroring

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • Rudy Panigas

    SSChampion

    Points: 10695

    Nicely done!

    I have a question, is the order of the scripts the order of execution?

    Thanks,

    Rudy

    Rudy

  • ImYourDBA

    SSCertifiable

    Points: 5654

    Rudy Panigas (7/13/2010)


    Nicely done!

    I have a question, is the order of the scripts the order of execution?

    Thanks,

    Rudy

    Yes, the order of the scripts is the order of execution. I should say that the scripts are written to use a Pull subscription with queued updates also.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • Robert Davis

    One Orange Chip

    Points: 28027

    One recommendation for script #4 would be to explain how to use sp_help_agent_profile to determine the correct @profile_id for sp_add_agent_parameter. It appears that you are supplying the agent_type value rather than the profile_id value for the subsequent calls to sp_add_agent_parameter. Some of those values may be the same, some may not. This is especially true if you decide to create custom agent profiles for the replicaiton topologies that use mirroring (which is the best practice I call out in my book).


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • carlosjose.gonzalez

    SSC Rookie

    Points: 40

    I have doubts that would happen if our publication has multiple subscribers, and these in the future would have also would have mirror

    settings as serious

    the current is so

      -PublisherFailoverPartner: server2

    but since that publication, subscribe multiple servers as serious

      -PublisherFailoverPartner: serverA2, serverB2, serverC3

    this could be?

  • Robert Davis

    One Orange Chip

    Points: 28027

    No, you can only have one mirror of a database.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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