January 22, 2009 at 3:44 am
Anybody had any experience of combining database mirroring and replication?
We want to use transactional replication on a database that is being mirrored to a second server in a high availability configuration, i.e. a witness server.
We'd be replicating to a separate server that would act as the distributor as well.
January 22, 2009 at 5:18 am
Check out this article:
[font="Verdana"]Markus Bohse[/font]
January 22, 2009 at 5:42 am
I should just point out we're using SQL Server 2005, no plans to go to 2008 for a good few years.
January 22, 2009 at 5:55 am
When it comes to replicating a mirrored database I don't think there is a lot of difference between 2005 and 2008. Transactional replication hasn't changed at all and mirroring too has undergone only minor changes.
[font="Verdana"]Markus Bohse[/font]
January 23, 2009 at 1:44 pm
Mirroring is a bit easier in 2008 with the registry entry made for the failover by applications.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply