Options for SQL Server in-place Rollback :(

• matthewful3

  SSC Veteran

  Points: 205

  More actions

  July 19, 2016 at 1:09 pm

  #400435

  I am in the process of upgrading our sql servers from 2012 to 2014. I kind of jumped the gun and went and upgraded my dev cluster with an in-place upgrade and didn't have any problems. Unfortunately I was told by a vendor they do not recommend an in-place upgrade (this was my fault for not researching this) Now I need to test my migration plan but my I am not sure how to roll back my dev cluster to 2012.

  Now I do have backups of my 2012 databases and everywhere I read it says I need to uninstall 2014 and and reinstall 2012 and restore the backups. I am a little lost how to do this. As I cant seem to uninstall an instance do I need to remove it form the node first? Then uninstall the instance? Then basically set up a new 2012 cluster and restore backups to there respected instance?

  Background:

  I have a 3 node cluster. I have 16 instances on the cluster and the majority of them are on 2014 some were left on 2012 as we knew they would have problems.

  So my first possible problem is I need to keep one instance on 2014.

  Alternative solutions:

  We do have backups of each drive and the OS (not a VM so no snapshot) would it be possible to restore this to before the upgrade? Granted we would lose all data after the upgrade but I think we may be ok with that. as our backups hours before the upgrade took place so either way we will be losing data I assume.

  I know sql has a task that will generate scripts where you can script the db out to use an older sql version would this work? I would assume it would be a similar process as to restoring the backups after setting up a new cluster but we wouldn't lose any data. (This one may not even be considered as one instance has over 400 databases)