Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Availability group planning with MSDTC as a requirement Expand / Collapse
Author
Message
Posted Tuesday, July 09, 2013 10:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 3:05 PM
Points: 17, Visits: 63
We've got a number of clustered SQL 2008 instances and currently use transactional replication to copy data off to a secondary database to use as a datasource for reporting purposes.

I'd like to migrate to SQL 2012 and utilize availability groups to point reporting to a read-only secondary replica to eliminate database replication. The application we have requires the use of MSDTC.

Where I'm kind of running into a brick wall is on what this means for my use of availability groups. Does this mean that I can't use availability groups AT ALL? Or does it just mean that I need to utilize FCI based instances for my availability group members?

Basically, I want read-only secondary replicas AND MSDTC, am I asking too much? :)
Post #1471727
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse