Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

AlwaysOn and Database Mirroring Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 10:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item AlwaysOn and Database Mirroring






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1522569
Posted Thursday, December 12, 2013 10:29 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:21 PM
Points: 1,762, Visits: 766
Great question - thanks Steve

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1522570
Posted Friday, December 13, 2013 1:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 4,021, Visits: 5,317
Interesting question, thanks Steve
Learned something new today.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1522600
Posted Friday, December 13, 2013 5:46 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 20, 2014 6:00 AM
Points: 588, Visits: 276
Steve, nice question. Took about a second to answer it because I set this environment up in development instances and will be promoting to production. I love clustered mirrors.
Post #1522641
Posted Friday, December 13, 2013 5:46 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 4,233, Visits: 3,667
That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the favored flavor.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1522642
Posted Friday, December 13, 2013 6:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 20, 2014 6:00 AM
Points: 588, Visits: 276
Ed Wagner (12/13/2013)
That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the favored flavor.


Yes, it is true. "Database mirroring" will be a thing of the past for SQL Server 2012 and greater and AlwaysOn group is the preferred method. Cross database transactions can be of issue as well, even with an AlwaysOn, because they are not supported but there are always workarounds. I have had to do this in RAID (mirrored servers) Clustered environments for years.

Architecting the solution is always "fun."
Post #1522660
Posted Friday, December 13, 2013 12:27 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, October 20, 2014 11:29 AM
Points: 3,354, Visits: 2,001
Nice question Steve. Thanks.
Post #1522834
Posted Sunday, December 15, 2013 11:39 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:27 AM
Points: 1,321, Visits: 632
Ed Wagner (12/13/2013)
That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the favored flavor.

+1
Post #1523095
Posted Monday, December 16, 2013 12:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 13,275, Visits: 11,062
Great question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1523099
Posted Monday, December 16, 2013 12:15 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:24 AM
Points: 966, Visits: 1,166
A good question ,learned something.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1523101
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse