June 18, 2010 at 1:14 pm
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/
July 13, 2010 at 9:02 am
Nicely done!
I have a question, is the order of the scripts the order of execution?
Thanks,
Rudy
Rudy
July 15, 2010 at 7:39 am
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/
June 28, 2011 at 7:18 am
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).
May 15, 2013 at 9:01 am
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?
May 15, 2013 at 7:58 pm
No, you can only have one mirror of a database.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply