This should be easy, but the MS docs are not clear.
The docs: http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.100%29.aspx
Indicate that in Standard edition, the only supported mirroring is "safety full only"
Taken together with this document: http://technet.microsoft.com/en-us/library/ms191456(v=sql.105).aspx
The answer would seem to be:
In SQL Server 2008, async, high performance mirroring is only available in Enterprise Edition
Correct?
marc_s
9,0626 gold badges46 silver badges52 bronze badges
asked Oct 27, 2013 at 19:15
Jonesome Reinstate Monica Jonesome Reinstate Monica
3,48910 gold badges40 silver badges57 bronze badges
-
1What, in any of these docs, leads you to believe this is available in standard edition?Aaron Bertrand– Aaron Bertrand2013年10月27日 23:05:51 +00:00Commented Oct 27, 2013 at 23:05
1 Answer 1
In the first document you list, it is clearly stated that Asynchronous Mirroring is only supported in the Enterprise Edition of SQL Server 2008.
Synchronous Mirroring is available in the Standard Edition.
answered Oct 28, 2013 at 0:06
-
In the first document it says "Asynchronous database mirroring is supported only by SQL Server 2005 Enterprise Edition SP1 and later versions." The document is for SQL 2008, so you kind of have to assume the story for SQL 2008.Jonesome Reinstate Monica– Jonesome Reinstate Monica2013年10月28日 04:13:46 +00:00Commented Oct 28, 2013 at 4:13
-
Not when the document is titled "Features Supported by the Editions of SQL Server 2008"2013年10月28日 13:15:21 +00:00Commented Oct 28, 2013 at 13:15
lang-sql