6 Steps to setting up Replication with Mirroring

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jacob Golden » 6 Steps to setting up Replication with...

6 Steps to setting up Replication with Mirroring

Rate Topic

Display Mode

Topic Options

Author

Message

SQLJocky

Posted Friday, June 18, 2010 1:14 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:35 AM
Points: 146, Visits: 546

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

Post #939826

Rudy Panigas

Posted Tuesday, July 13, 2010 9:02 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 306, Visits: 1,016

Nicely done!

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

Thanks,

Rudy

Post #951528

SQLJocky

Posted Thursday, July 15, 2010 7:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:35 AM
Points: 146, Visits: 546

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

Robert Davis

Posted Tuesday, June 28, 2011 7:18 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 1:05 PM
Points: 1,559, Visits: 1,397

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
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1132863

carlosjose.gonzalez

Posted Wednesday, May 15, 2013 9:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:54 AM
Points: 4, Visits: 101

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

Robert Davis

Posted Wednesday, May 15, 2013 7:58 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 1:05 PM
Points: 1,559, Visits: 1,397

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

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1453301

« Prev Topic | Next Topic »

Permissions