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

Convert Mirroring to Log Shipping Expand / Collapse
Author
Message
Posted Friday, August 20, 2010 12:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 17, 2015 10:23 AM
Points: 1,622, Visits: 1,575
Interesting article. I've converted log shipping to mirroring lots of time but never considered any use cases for the reverse. Nice thoughts!!



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Principal Database Architect (consultant) at DB Best Technologies
Post #972296
Posted Friday, August 20, 2010 9:09 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 21, 2015 10:01 AM
Points: 721, Visits: 710
So....

Why not just fail over to the secondary full time, so that you can upgrade the primary offline. If all goes well, fail back to the primary, if not, the secondary keeps on running until the issues are resolved? No down time at all.
Post #972608
Posted Friday, August 20, 2010 11:19 AM
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: Yesterday @ 2:19 PM
Points: 3,234, Visits: 3,573
Dan Guzman - Not the MVP (8/20/2010)
So....

Why not just fail over to the secondary full time, so that you can upgrade the primary offline. If all goes well, fail back to the primary, if not, the secondary keeps on running until the issues are resolved? No down time at all.



You would have to break mirroring or log shipping in order to have both primary and secondary databases online at the same time. How would you reconcile the difference between the primary which has the code upgrade applied and the secondary which has had user transactions running against it?
Post #972711
Posted Friday, August 20, 2010 11:25 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 21, 2015 10:01 AM
Points: 721, Visits: 710
Duh. Yes, of course, you are correct.
Post #972717
Posted Monday, August 23, 2010 2:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 11:29 PM
Points: 138, Visits: 236
Same also applies for LS in case of Recovery model is full, it can hold transactions till log file grows. Only +ve point of LS over log size is that it uses Bulk Load recovery model.
Post #973273
Posted Thursday, September 2, 2010 4:08 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Tuesday, August 18, 2015 7:23 PM
Points: 9,932, Visits: 11,288
A very good article - I have no idea why it's rating is so low.
Well done.




Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Post #979385
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse