SQL Server 2005 Tidbit 008

  • Article

SQL Server 2005 Tidbit 008

Happy SQL People

Tidbit #8

This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me." 

—

“Database mirroring, or parts of it, is available in Standard Edition of Yukon. What's the difference between what you get with Enterprise Edition and Standard Edition?”

Mirroring is supported in both Standard and Enterprise Editions of SQL Server 2005.  According to the feature comparison page, in Standard there is only a single REDO Thread (on the mirror instance), and the "safety setting" is always on.

And again – here is a great resource on Mirroring: 
https://download.microsoft.com/download/f/8/5/f8520d64-f109-4111-b0b0-51f1f6d2d220/ProSQLServer2005_Ch15_ForTechEd.pdf

—

Got an IT question?  Give me a comment, or contact me.