开发者

Configuring replication after mirroring - is this possible?

开发者 https://www.devze.com 2023-01-14 09:56 出处:网络
I\'m currently setting up replication in order to produce a database that will be used to run reports and take load of the main database.

I'm currently setting up replication in order to produce a database that will be used to run reports and take load of the main database.

According to the guide at: http://msdn.microsoft.com/en-us/library/ms151799(v=SQL.90).aspx

You setup mirroring, which we use for high availability after the publisher has been configured. I was wondering if there is any problems doing it the other way around so we don't have to change our exist开发者_运维技巧ing mirroring configuration, we just add the publication and configure the replication options accordingly?


The answer is right in the link you cited.

Configuring replication and database mirroring involves five steps. Each step is described in more detail in the following section.

  1. Configure the Publisher.
  2. Configure database mirroring.
  3. Configure the mirror to use the same Distributor as the principal.
  4. Configure replication agents for failover.
  5. Add the principal and mirror to Replication Monitor.

Steps 1 and 2 can also be performed in the opposite order.[emphasis added]

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号