July 17, 2017 at 8:14 am
GOing to do in place upgrade from 2012 to 2014. Currently have log shipping. I believe it is supposed to survive the upgrade but was going to try following plan.
1.Stop log shipping backup at 10 PM
2.Restore last file backed up to read only node
3.Upgrade primary server to 2014.
4.upgrade read only node to 2014
Start log shipping back up
July 17, 2017 at 9:40 am
tcronin 95651 - Monday, July 17, 2017 8:14 AMGOing to do in place upgrade from 2012 to 2014. Currently have log shipping. I believe it is supposed to survive the upgrade but was going to try following plan.1.Stop log shipping backup at 10 PM
2.Restore last file backed up to read only node
3.Upgrade primary server to 2014.
4.upgrade read only node to 2014
Start log shipping back up
A) I have advised my clients against doing in-place upgrades since, well, forever.
B) I am pretty sure that if you have Standby mode enabled on secondary this will fail.
C) Even without that I would be prepared to redo your log shipping.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 17, 2017 at 9:47 am
not a choice with this one so will have to wing it.
July 17, 2017 at 11:34 am
tcronin 95651 - Monday, July 17, 2017 9:47 AMnot a choice with this one so will have to wing it.
Good luck. I sure hope this isn't a critical production system. That's a bad phrase to be using if it is. Should it be, I would most definitely be setting up a test environment to know for certain how it is going to play out.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 17, 2017 at 11:56 am
I'd be prepared to script out everything and ready to re-set Log Shipping.
Make sure you have backups of all logins and linked servers, as well as user dbs.
July 17, 2017 at 11:57 am
TheSQLGuru - Monday, July 17, 2017 11:34 AMI would most definitely be setting up a test environment to know for certain how it is going to play out.
This, x100
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 21, 2017 at 5:18 am
tcronin 95651 - Monday, July 17, 2017 8:14 AMGOing to do in place upgrade from 2012 to 2014. Currently have log shipping. I believe it is supposed to survive the upgrade but was going to try following plan.1.Stop log shipping backup at 10 PM
2.Restore last file backed up to read only node
3.Upgrade primary server to 2014.
4.upgrade read only node to 2014
Start log shipping back up
Use rolling upgrades, Sequence should be
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply