Hyper V Migration Windows and SQL Cluster 2008 R2 ??

Nikhil Desai 21 Reputation points
2021-02-17T09:39:52.537+00:00

Hi,

We have Hyper-V with SQL Server Cluster (Active-Passive). Windows cluster is 2008 R2 Enterprise Edition & SQL Server Cluster 2008 R2 Enterprise Edition. We want to migrate both active and passive server to new Rack Server having new hardware & storage with same IP, Hostname, Same Version & Edition without Creating new Windows & SQL Server on new Rack Server.

Is this possible in Hyper-V ??

Thanks in advance.

Regards,
Nikhil P Desai

Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,538 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
958 questions
Windows Server Migration
Windows Server Migration
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Migration: The process of making existing applications and data work on a different computer or operating system.
408 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Xiaowei He 9,871 Reputation points
    2021-02-18T07:01:43.96+00:00

    Hi,

    Is this possible in Hyper-V ??

    Do you mean the Hyper V VMs are Server 2008R2 with SQL server 2008R2 and you use the VMs to create the SQL Cluster, now, you want to migrate the SQL service to physical server with new hardware, storage with same IP, same version?

    If my understanding is correct, I think you want to do V2P that convert virtual VM to physical server. Actually, there's no offficail method to do V2P and not recommended to do V2P. But if you want to learn about it, you may refer to the following article:

    https://www.altaro.com/hyper-v/virtual-to-physical-conversions-v2p/

    (Please note: Information posted in the given link is hosted by a third party. Microsoft does not guarantee the accuracy and effectiveness of information.)

    Thanks for your time!
    Best Regards,
    Anne

    -----------------------------

    If the Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Xiaowei He 9,871 Reputation points
    2021-02-23T03:33:19.373+00:00

    Hi,

    We are looking for Hyper-V V2V migration.

    Please check if the following article could be of help:

    https://www.mssqltips.com/sqlservertip/5774/upgrade-or-migrate-a-sql-server-failover-clustered-instance-while-using-the-same-virtual-network-name-and-virtual-ip-address-option-1/

    (Please note: Information posted in the given link is hosted by a third party. Microsoft does not guarantee the accuracy and effectiveness of information.)

    Thanks for your time!
    Best Regards,
    Anne

    -----------------------------

    If the Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. Alex Bykovskyi 1,681 Reputation points
    2021-02-26T15:59:58.05+00:00

    Hey,

    In my opinion, it would be better to create new virtualized cluster and migrate databases to a new cluster. The following articles might be helpful:
    https://learn.microsoft.com/en-us/sql/relational-databases/databases/copy-databases-to-other-servers?view=sql-server-ver15
    V2V is still an option. You can use StarWind V2V Converter to move your VMs to a new hardware:
    https://www.starwindsoftware.com/starwind-v2v-converter

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    0 comments