How can we help you today? How can we help you today?

In-place upgrade of SQL Server

I want to carry out an in-place upgrade of the SQL Server instance used by SQL Clone. The current version is 2012 and I want upgrade to 2016. Does anyone know if during the upgrade the existing database clones are effected, ie can they still be used while the upgrade is taking place?
Iain_Targett
0

Comments

2 comments

  • Diogo
    The database clones should behave in the same way as any other database.
    This documentation from Microsoft suggests that there might be downtime and that the instance will be overwritten so may be the clones won't be available after upgrading.

    So the best approach might be to just recreate the clones after upgrading your SQL Server instance.
    Diogo
    0
  • Iain_Targett
    Thank you. I don't think I worded my question very well. I was upgrading the instance of SQL Server used by SQL Clone, ie where the database SQLClone_Config is. The same server is also where the database images are kept. It did work OK. I was able to update the SQL Server instance and the developers could continue using the database clones on there own instances.
    Iain_Targett
    0

Add comment

Please sign in to leave a comment.