Solved

SQL server 2012 and 2014 mirror replication

Posted on 2014-04-16
11
1,591 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
  • 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
 
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now