Morning Everyone :-)
I know this is a topic that has been widely discussed and I have read through a few articles on it but I cant seem to find an answer to my issue
I'm hoping some of the great minds here may be able to lend me a helping hand :-D I am working with the following setup listed below:Server A:
Principal - PublisherServer B:
Distributor - Subscriber
Mirroring is setup and works fine with no issues, however I'm trying to make the system automatically failover to the following setup should Server A fail:Server A:
Principal - Publisher. Server C:
Distributor - Subscriber.
I have read up on setting the -PublisherFailoverPartner
to be Server B but the information I have gone through has left me fairly confused
I cant seem to figure out how the local publication on Server A will transfer to Server B when the -PublisherFailoverPartner comes into effect?
I would really appreciate any help you can give :-) Oh and the specs for the servers are also listed below, thanks again.Specs:
Windows Server 2008 R2 Standard
SQL Server 2008 R2