December 26, 2015 at 8:32 am
Hi All,
Please let me know which service pack is needed on various Edition of SQL Server (2008, 2008R2, 2012 and 2014) to configure Database Mirroring ?
Regards,
Nikhil P Desai
December 27, 2015 at 1:11 am
I don't have a list. However, https://support.microsoft.com/en-us/search?query=kbhotfixrollup%20%22database%20mirroring%22 should get you close to an answer.
I also suggest you very carefully review https://support.microsoft.com/en-us/kb/2729953, consider there are at least two issues that can only be resolved by 2012. Until 2012, the consequence of hitting those two issues will be "the mirror pair must be rebuilt". Both issues are related to a parent lock being a system lock, which a 2008 R2's log file format cannot log (while 2012's log file format can). Database mirroring also has been deprecated (see note at top of https://msdn.microsoft.com/en-us/library/ms189852.aspx).
December 28, 2015 at 11:11 am
Database Mirroring is available on SQL 2005 SP1 onwards. It is built in to the RTM versions of all more recent versions of SQL Server.
There will be fixes for data mirroring problems in all SPs of all versions, and in most CUs. It is best for a new build to be using the latest SP and CU.
Although Data Mirroring is deprecated, it will still be available in SQL 2016. From SQL 2016 onwards there is a basic form of Availability Groups that will replace database mirroring in subsequent versions of SQL Server.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply