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

6 Steps to setting up Replication with Mirroring Expand / Collapse
Author
Message
Posted Friday, June 18, 2010 1:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:22 PM
Points: 171, Visits: 681
Comments posted to this topic are about the item 6 Steps to setting up Replication with Mirroring
Post #939826
Posted Tuesday, July 13, 2010 9:02 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
Nicely done!

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

Thanks,

Rudy




Post #951528
Posted Thursday, July 15, 2010 7:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:22 PM
Points: 171, Visits: 681
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.
Post #953130
Posted Tuesday, June 28, 2011 7:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 12:08 PM
Points: 1,618, Visits: 1,553
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
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1132863
Posted Wednesday, May 15, 2013 9:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 21, 2013 11:12 AM
Points: 4, Visits: 138
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?
Post #1453161
Posted Wednesday, May 15, 2013 7:58 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 12:08 PM
Points: 1,618, Visits: 1,553
No, you can only have one mirror of a database.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1453301
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse