P2V of Windows 2008 R2 SQL Clustered Servers

RanaSaha-1602 21 Reputation points
2021-02-24T11:18:16.467+00:00

Hello, Is it possible to convert P2V of Windows 2008 R2 SQL clustered environment?

Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,532 questions
Accepted answer
  1. Dave Patrick 426.1K Reputation points MVP
    2021-02-24T13:37:25.623+00:00

    You may be able to break the cluster and get it to work. P2V is a poor and very risky solution

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Xiaowei He 9,871 Reputation points
    2021-02-25T06:07:27.38+00:00

    Hi,

    It's not recommended to convert P2V, if you want to migration SQL cluster from physical servers to virtual machines. We may try to create the cluster on virtual machines, then try to migrate SQL cluster to it. After migration, we may try to change the IP addresses settings, if you want o use the orignal ones.

    I found an article about how to migrate SQL instance to new Cluster, for your reference:

    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.

    0 comments
  2. Alex Bykovskyi 1,831 Reputation points
    2021-02-25T16:19:11.32+00:00

    Hey,

    I think the best way would be to create new virtualized cluster and migrate databases to a new cluster. P2V of SQL can lead to a potential issues and is not recommended. 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
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

    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