Database A has a Transactional Repl Pub...
Database B has a Subscription to the Pub on A(push from Pub to Sub)...
Database B is part of a DB mirror to DB C and is the Primary...
Database C is in mirrored mode... Sub cannot be setup to C as it is not
seen...
Failover to C for the mirror making it primary... Pub cannot talk to B and
agent stops...
Sub was established before mirror was created... should mirror be broken,
sub deleted, mirror created and sub added??? or is this the scenario they
say they do not support (which would be bad on their part)...
[quoted text, click to view] "Paul Ibison" wrote:
> From BOL:
> "Replication failover to a mirror is supported for publication databases
> only; it is not supported for the distribution database or subscription
> databases".
> As far as I understand your scenario, you should be ok. What errors are you
> seeing? What type of replication publication do you have etc?
> Cheers,
> Paul Ibison SQL Server MVP,
www.replicationanswers.com > (recommended sql server 2000 replication book:
>
http://www.nwsu.com/0974973602p.html)
>
>
I read somewhere on Microsoft MSDN that replication combined with database
mirroring is not supported...
I have the same issue myself and if this is true, then clustering is a
better solution.
Per Schjetne
[quoted text, click to view] "TAbbott" <TAbbott@discussions.microsoft.com> wrote in message
news:8BF628C6-ACFE-48D3-8387-9240C8EAA883@microsoft.com...
> Environment:
> Database A with subscrition to a transactional replication pub...
>
> Datatase A is the primary in a database mirror configuration...
>
> In failover to Database B everything is fine except the subscription when
> in
> the failover mode...
>
> How do I configure this environment such that in failover to Server B, the
> subscription to the trans. repl. pub. still works???
>
> (Already attempted to do the failover to B and setup the subscription
> again
> but the system did not like that... did I miss a step?)
>
> Thank you for any and all thoughts...
From BOL:
"Replication failover to a mirror is supported for publication databases
only; it is not supported for the distribution database or subscription
databases".
As far as I understand your scenario, you should be ok. What errors are you
seeing? What type of replication publication do you have etc?
Cheers,
Paul Ibison SQL Server MVP,
www.replicationanswers.com (recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
