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."