Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally, but somehow force synchronous replication for one table between nodes?

Nodes are in different subnets/continents.

Thank you in advance.

share|improve this question
add comment

1 Answer

Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally

Yes, with AlwaysOn Availability Groups having commit mode set to asynchronous commit for a replica. That'll be by-database, so you'll have to group the databases into the AG that you want to see that happen with.

but somehow force synchronous replication for one table between nodes

It really depends on your definition of "synchronous", but in the truest of definitions then no, you can't have synchronous commit for individual tables. It'd have to be by database/availability group.

share|improve this answer
    
+1 You could put that table only in a different database and hence a different AG. –  Aaron Bertrand Dec 17 '13 at 16:05
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.