September 29, 2011 at 7:57 pm
Hi all,
It is possible to create mirroring on top of transactional replication while replication is running or mirroring has to be created first and then replication?
I am not planning to make logreader or snapshot agents to be fail over aware.
September 29, 2011 at 9:45 pm
I have not tried this but it is possible. You could get more information from this whitepaper which describers your scenario
http://download.microsoft.com/download/d/9/.../replicationanddbm.docx
M&M
September 30, 2011 at 1:01 am
Thank you for the reply, but it seems that i can't access that file. This is the error i am getting: 404 - File or directory not found
September 30, 2011 at 1:27 am
Follow the guidelines, I think this should help you
September 30, 2011 at 2:08 am
Mirror it first.
per MSDN:
Typically, when combining log shipping and database mirroring, the mirroring session is established before log shipping, although this is not required. Then the current principal database is configured as the log shipping primary (the principal/primary database), along with one or more remote secondary databases. Also, the mirror database must be configured as a log shipping primary (the mirror/primary database). The log shipping secondary databases should be on different server instances than either the principal/primary server or mirror/primary server.
September 30, 2011 at 2:16 am
Is the log shipping the same as replication?
September 30, 2011 at 5:18 am
e90fleet (9/30/2011)
Is the log shipping the same as replication?
I think below links should be of help.
http://www.sqlservercentral.com/Forums/Topic482924-149-1.aspx
http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/
M&M
September 30, 2011 at 5:26 am
In Replication you define the articles for publication which could be a subset of database e.g. few tables. Log Shipping works on a database as whole.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply