Solved

SQL server 2012 and 2014 mirror replication

Posted on 2014-04-16
11
1,641 Views
Last Modified: 2014-04-26
I read this http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx and http://msdn.microsoft.com/en-us/library/cc645993.aspx , standard editoin SQL server 2014 and 2014 only support synchronous database mirroring, anyway to use te async mode on SQL 2012 or 2014? AlwaysOn groups is the one ?
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 40006028
No. Async mode is only available in the Enterprise edition.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40006041
"Async mode is only available in the Enterprise edition. "

you mean from the link I post.. the mirror replication is "Yes" for Enterprise edition and only this inlucde the async mode?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40006043
what version of SQL server you are using ? did you try that asyn mode yet?
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 52

Expert Comment

by:Carl Tawn
ID: 40006044
We use Enterprise, because we need to use async mirroring to our remote data centre.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40006047
2012 I guess? not that proactive to use 2014 , right?
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 40006049
Mixture of 2008R2 and 2012. No, no 2014 in production yet :)
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40006069
2008 R2 also need enterprise edition for async mode ?
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 40006075
Yes. Async mode is only supported in Enterprise edition, regardless of which version.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40006103
we are using SQL 2005 standard edition x86 and this is what we mean sync mode ?
sync modeEpicro-sync.jpg
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 40006117
Yes. Synchronous mode is also know as "High Safety" mode. Asynchronous mode is known as "High Performance" mode. But Asynchronous/High Performance mode is still only available in Enterprise edition.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40006119
yeah, thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question