March 30, 2016 at 1:21 am
Hello
I have an environment with two physical node, server1 and server2. Both of them are part of the SQL Server Cluster installation whos name's is SQL1 (the sql server version is 2008).
Now I'am planning to migrate this SQL Server instance to a new SQL Server 2014 standalone who will be in a new virtual machine; this server name will be the same that the old sql server cluster name (SQL1). For the migration solution I have two requirements:
1) I have ensure to "restore" the old cluster environment (if there are any problems during the migration).
2) I need to minimice the required downtime for migration.
¿which would be the steps for do it? ¿Somebody know any documentation about it?
Thanks.
March 30, 2016 at 7:06 am
You could set up log shipping for the databases from your 2008 clustered instance over to the new 2014 vm instance. Then, at cutover time, stop all applications pointing to the old environment, break log shipping, then bring up the databases on the secondary (new 2014 vm) and then point the application(s) to the newly upgraded databases. When the databases are restored initially, when setting up log shipping to the secondary, the databases will be upgraded automatically and then the logs will be applied. The important thing to remember is, once you migrate to the new environment, you will no longer be able to keep the old and new in sync as you cannot log ship from a newer version to an older version. So, it will be very important that once you cutover, to ensure that it is a "go" and that there are no issues. You must take new full backups of the old instance's databases prior to beginning the migration and breaking log shipping. This is only one way to do as there are other ways, this is the one way that could work for you if your environment and application permits. Hope this helps!
April 2, 2016 at 12:06 pm
ico-601891 (3/30/2016)
HelloI have an environment with two physical node, server1 and server2. Both of them are part of the SQL Server Cluster installation whos name's is SQL1 (the sql server version is 2008).
Now I'am planning to migrate this SQL Server instance to a new SQL Server 2014 standalone who will be in a new virtual machine; this server name will be the same that the old sql server cluster name (SQL1). For the migration solution I have two requirements:
1) I have ensure to "restore" the old cluster environment (if there are any problems during the migration).
2) I need to minimice the required downtime for migration.
¿which would be the steps for do it? ¿Somebody know any documentation about it?
Thanks.
You wont be able to use the virtual networkname currently assigned to the FCI for the new standalone server.
You'll have to name the new server something temporary, migrate all objects then take the clustered resources down and rename the new server to have the new computername
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply