Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
 Posted - 2008-04-30 : 08:53:02
|
| Hi,I am trying to setup mirrored subcriber in Transactional Replication in SQL 2005. I am not able to do so as it don't work after failover.However I am able to setup mirrored publisher with distribution property "PublisherFailoverPartner" for snapshot and log reader agent profiles and it works even after failover.However I need to know, do we have something called "Subscriberfailoverproperty" or any other method to set up mirrored subscriber in Transactional Replication in SQL 2005.ThanksKiran Patil |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-30 : 10:31:14
|
| What you mean by mirrored subscribers? |
 |
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-04-30 : 12:18:36
|
| Mirrored Subscriber :-I want to make subscriber as Principal database in Mirroring.And I want to keep replication working even after failover.Hope I am clear this time. Please revert if still I am not clear.ThanksKiran Patil |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 22:15:54
|
| Replication on clustered sql works after failover, not sure what you mean. |
|
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-05-01 : 09:04:55
|
| ok, Let me explain again.I have three SQL 2005 servers, lets say A (with Database Test1 as Publisher), B (with Database Test2 as subscriber) and C (with database Test2 as mirrored database). Transactional Replication is setup between server A (database Test1) and server B (Database Test2). The database mirroring is also setup between database Test2 on server B as Principal database and database Test2 on server C as mirrored database.So far all working fine, Replication and mirroring, problem arises when I make failover in mirroring from database Test2 on server B to database Test2 on server C, the replication doesn't work.As replication will try to find database Test2 on server B as subscriber, which will be in reocvery state after database mirroring failover.Now I want to instruct replication to look for database Test2 on server C and not server B. How do I do that.Please revert, if still I am not clear.ThanksKiran Patil |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-01 : 09:33:17
|
| Remember transactional replication is not HA option. It is not automatic . If it was then why we would need database mirroring. You have to manually change subscriber or replicate to both subscribers with Tran rep. |
|
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-05-01 : 10:46:07
|
| ok, Let me explain my working scenerio.I have three SQL 2005 servers, lets say A (with Database Test1 as Publisher, principal database in mirroring), B (with Database Test2 as subscriber) and C (with database Test1 as mirrored database). Transactional Replication is setup between server A (database Test1) and server B (Database Test2). The database mirroring is also setup between database Test1 on server A as Principal database and database Test1 on server C as mirrored database.All working fine, Replication and mirroring, when I make failover in mirroring from database Test1 on server A to database Test1 on server C,Replication still runs without error,considering Test1 on Server C as Publisher and Test2 on server B as Subscriber, replication is finding its new publisher automatically.I could do this by setting PublisherFailoverpartner property at distribution server. Find the link below for the same.http://msdn.microsoft.com/en-us/library/ms151799.aspxAs this is possible for Publisher (Principal in Mirroring) , I want to know if this is also possible for subscriber (if principal in mirroring). ThanksKiran PatilThanksKiran Patil |
|
|
|
|
|
|
|
|
Mirrored Subscriber in Transactional Replication ?