DB mirroring support MSSQL 2014

Question

DB mirroring support MSSQL 2014

niall5098

Right there with Babe

Points: 749
More actions
March 3, 2016 at 6:25 am

#324657

HI There,
i am attempting to get a definitive answer on whether or not DB mirroring is supported in SQL Server 2014. I know MS have stated that it will be deprecated since the release of 2012 but its still there. does anyone have any links or text that specifically says yes it is supported in 2014?
Thanks in advance,

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Deprecated doesn't mean 'not supported'. It means that it will be removed in a future version.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Phil Parkin SSC Guru Points: 246993 More actions · Answer 2

nialldunne (3/3/2016)
HI There,
i am attempting to get a definitive answer on whether or not DB mirroring is supported in SQL Server 2014. I know MS have stated that it will be deprecated since the release of 2012 but its still there. does anyone have any links or text that specifically says yes it is supported in 2014?
Thanks in advance,

It is. I have used it.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

niall5098 Right there with Babe Points: 749 More actions · Answer 3

niall5098

Right there with Babe

Points: 749

March 3, 2016 at 6:45 am

#1862725

Good stuff, thanks for the clarification

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 4

I can promise you that I will still have clients using mirroring at least 10 years from now, probably 15.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

BLOB EATER SSChampion Points: 14609 More actions · Answer 5

TheSQLGuru (3/3/2016)
I can promise you that I will still have clients using mirroring at least 10 years from now, probably 15.

Is that because it is a stable feature of much use?

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 6

Yes to all of what you said. And it is available on Standard Edition, as opposed to "Always On", although I think a dumbed-down version of that is being released in SE on 2016+ IIRC.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Phil Parkin SSC Guru Points: 246993 More actions · Answer 7

TheSQLGuru (3/3/2016)
Yes to all of what you said. And it is available on Standard Edition, as opposed to "Always On", although I think a dumbed-down version of that is being released in SE on 2016+ IIRC.

Is that anything more than a rumour? Is there a list somewhere of what is in SE 2016?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 8

It is confirmed here: https://msdn.microsoft.com/en-us/library/mt614935.aspx

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

TheSQLGuru (3/3/2016)
It is confirmed here: https://msdn.microsoft.com/en-us/library/mt614935.aspx

Making it easier for others:

https://msdn.microsoft.com/en-us/library/mt614935.aspx

Phil Parkin SSC Guru Points: 246993 More actions · Answer 10

Thanks, guys.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel