• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1692
  • Last Modified:

SQL server 2012 and 2014 mirror replication

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
marrowyung
Asked:
marrowyung
  • 6
  • 5
1 Solution
 
Carl TawnSystems and Integration DeveloperCommented:
No. Async mode is only available in the Enterprise edition.
0
 
marrowyungAuthor Commented:
"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
 
marrowyungAuthor Commented:
what version of SQL server you are using ? did you try that asyn mode yet?
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
Carl TawnSystems and Integration DeveloperCommented:
We use Enterprise, because we need to use async mirroring to our remote data centre.
0
 
marrowyungAuthor Commented:
2012 I guess? not that proactive to use 2014 , right?
0
 
Carl TawnSystems and Integration DeveloperCommented:
Mixture of 2008R2 and 2012. No, no 2014 in production yet :)
0
 
marrowyungAuthor Commented:
2008 R2 also need enterprise edition for async mode ?
0
 
Carl TawnSystems and Integration DeveloperCommented:
Yes. Async mode is only supported in Enterprise edition, regardless of which version.
0
 
marrowyungAuthor Commented:
we are using SQL 2005 standard edition x86 and this is what we mean sync mode ?
sync modeEpicro-sync.jpg
0
 
Carl TawnSystems and Integration DeveloperCommented:
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
 
marrowyungAuthor Commented:
yeah, thanks.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now