Post reply

Cloning Windows Server to New Server - Will SQL Server work?

  • September 2, 2008 at 5:46 am

    #126149

    Hi,

    We wanted to do a POC. Standalone windows server need to be cloned by taking a snapshot image and need to be restored to a VMWare Virtual Machine. Will SQLServer work in the new VM Server automatically?

    Anyone has tried this method? Please let this forum know about your experience!

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • September 2, 2008 at 6:37 am

    #865939

    After the cloning, I assume you will change the IP address and server name on the cloned server. The server name change will end up with the @@ServerName variable returning the old server name. This needs to be fixed by dropping and re-adding the server again.

    Beyond that, it should work fine. I have done it a few times.

  • September 2, 2008 at 6:43 am

    #865944

    Hi

    If you are using a VMWare, then you can create a template mahcine and then clone from that machine, all you have to do is to change the instance name once cloned, and SQL works fine( assuming you are using one instance per server). you can use the below SQL to create a new instance name

    -- Check the instance name

    Select @@ServerName

    -- Drop the Instance

    SP_DropServer

    -- Add new Instance

    SP_addserver ,'Local'

    Then restart the SQL service

    This should change the instance name and your SQL server will work

    Cheers

    🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply