December 12, 2014 at 11:35 am
Hi -
I will be performing an active/active in place upgrade from SQL 2008 to SQL 2012 in two nodes, and I needed to know the rollout plan in case things go wrong. I read that for in-place upgrade, there is no rollout plan (I can't just uninstall the changes). I already have setup an environment where I migrated all databases from both nodes there as a backup plan. However I would like to know the answer to whether I can roll back or not.
Thanks.
December 12, 2014 at 1:59 pm
Let me correct myself, there is a rollout plan however it is not simple. The process involved uninstalling SQL 2012, reinstalling SQL 2008 and restoring databases. I just did not know if there is any better way which I am not aware of to do a quick rollout. In our shop we do not do image backup/restore so I will not have disk backup to restore from.
December 13, 2014 at 5:17 am
You can't really undo an in-place upgrade. You would have to uninstall everything and then restore your databases from a backup. You're pretty much making a commitment by doing your upgrade this way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 15, 2014 at 6:29 am
Grant - Thank you. I already setup another environment to restore to in case of failure as I understood that there is not an easy way to rollout in-place upgrade unless you uninstall everything and reinstall SQL 2008.
Thanks for your input.
December 17, 2014 at 1:22 am
And bear in mind that you can't downgrade SQL databases. Once the databases are attached to a SQL 2012 instance, they are SQL 2012 databases and will not attach or restore to SQL 2008
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 6:20 am
definitely.. I am taking backups prior to the upgrade and restore them else were in case of emergency. I already have two servers for that purpose.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy