December 7, 2017 at 3:32 pm
Hi,
Can someone please confirm that SQL Server 2016 SP1 does or doesn't do mirroring,
Kris
December 7, 2017 at 4:14 pm
Kris-155042 - Thursday, December 7, 2017 3:32 PMHi,
Can someone please confirm that SQL Server 2016 SP1 does or doesn't do mirroring,
Yes but it's being deprecated - it's been on the list for that since maybe SQL 2012 or so. You can find it in the list of supported features for the specific editions in SQL Server:
Editions and supported features of SQL Server 2016
Sue
December 7, 2017 at 5:31 pm
I saw that, but was does "Full Safety only" mean and how is that implemented
Kris
December 7, 2017 at 9:28 pm
Kris-155042 - Thursday, December 7, 2017 5:31 PMI saw that, but was does "Full Safety only" mean and how is that implemented
Full safety means that the transactional safety is set to FULL which implies that the operating mode is synchronous.
😎
December 8, 2017 at 8:00 am
Kris-155042 - Thursday, December 7, 2017 5:31 PMI saw that, but was does "Full Safety only" mean and how is that implemented
There are two transaction safety levels: - full and off - which are Safety Full and Safety off
Full transaction safety causes the session to operate synchronously in high-safety mode where the principal server waits for an acknowledgement from the mirror.
By default a session is set to full transaction safety so there really isn't anything special to do to implement this. You just set up mirroring following the documentation:
Setting Up Database Mirroring (SQL Server)
Sue
December 13, 2017 at 9:49 am
Sue_H - Thursday, December 7, 2017 4:14 PMKris-155042 - Thursday, December 7, 2017 3:32 PMHi,
Can someone please confirm that SQL Server 2016 SP1 does or doesn't do mirroring,Yes but it's being deprecated - it's been on the list for that since maybe SQL 2012 or so. You can find it in the list of supported features for the specific editions in SQL Server:
Editions and supported features of SQL Server 2016Sue
sql server 2014 was deprecated
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2017 at 11:14 am
Perry Whittle - Wednesday, December 13, 2017 9:49 AMSue_H - Thursday, December 7, 2017 4:14 PMKris-155042 - Thursday, December 7, 2017 3:32 PMHi,
Can someone please confirm that SQL Server 2016 SP1 does or doesn't do mirroring,Yes but it's being deprecated - it's been on the list for that since maybe SQL 2012 or so. You can find it in the list of supported features for the specific editions in SQL Server:
Editions and supported features of SQL Server 2016Sue
sql server 2014 was deprecated
Okay...so you made me look it up. It was 2012 when it was announced and it is still on the list of things to be deprecated in a future release.
Deprecated Database Engine Features in SQL Server 2012
Deprecated Database Engine Features in SQL Server 2016
Sue
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply