Solved

SQL server 2012 and 2014 mirror replication

Posted on 2014-04-16
11
1,630 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
Industry Leaders: 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!

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

751 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