March 4, 2014 at 9:58 pm
I have a 2008 R2 SP2 db set up as a Mirrored(syncronous) and LogShipped (2 hour delay) pair.
The requirement is to plan for the rollback of an upcoming system upgrade should it not go well. Is there a way it can be done without a downtime? If a downtime is inevitable, can I not have to rebuild mirroring or log shipping or both?
We will take a backup prior to app upgrade that will run for 4 hours. If it fails, we will need to go back to backup. Whats the safest way to achieve this?
Please let me know if any ideas around this. Much appreciated.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 6:40 am
What are you upgrading? SQL Server or the database schema/data?
In the case of schema/data changes I would take database snapshot if you're using Enterprise edition.
March 7, 2014 at 8:45 am
MysteryJimbo (3/7/2014)
What are you upgrading? SQL Server or the database schema/data?
I understand this will be a 90% schema upgrade and 10% data that uses the new schema
In the case of schema/data changes I would take database snapshot if you're using Enterprise edition.
Yes, it is enterprise edition.
In case we rollback the upgrade, we need to rollback all of the Principal/Mirror and Log Ship pair. So, although I did want to consider Snapshots I had some questions around it.
1. If the Snapshot needs to be taken just on the Principal? (Never tried snaps of a Mirror/Log ship secondary)
2. How much free space would I need to support the Snapshot sparse files?
3. Do I need to suspend Mirroring/Log Shipping while running the Snapshot?
4. Will restoring from Snapshot require re-establishing Mirroring and Log shipping?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply