locked
migrate sql server 2008 r2 to sql server 2008 r2 new host RRS feed

  • Question

  • migrate sql server 2008 r2 hyper-v to sql server 2008 r2 new host hyper-v

    Sorry guys accidentally submit button.

    I'm planning to migrate our database sql server 2008 r2 hyper-v to new host/server from current host. Details below:

    current hyper-v vm OS = Windows Server 2008 R2

    current db = SQL Server 2008 R2 with Cluster

    new hyper-v vm OS = Windows Server 2008 R2

    new db = SQL Server 2008 R2 without cluster

    Anybody have implement before ?

    I have short notice from client to perform above migration & would like to hear from forum the simplest way to implement it.

    Your contribution is very much appreciated. THANK YOU IN ADVANCE.

    • Edited by imra-ebi Monday, March 10, 2014 4:44 AM
    Monday, March 10, 2014 4:35 AM

Answers

  • Check below article to migrate to new hyper-v host, if helps!!

    https://blogs.technet.com/b/keithmayer/archive/2012/09/13/migrating-to-microsoft-hyper-v-server-2012-from-2008-r2-and-vmware-winserv-hyperv-itpro-vmware.aspx


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Proposed as answer by Sofiya Li Tuesday, March 11, 2014 8:11 AM
    • Marked as answer by Sofiya Li Monday, March 17, 2014 1:52 AM
    Monday, March 10, 2014 5:10 AM
  • Hello,

    I dont think this is much of complex thing to do.You create a new box by installing win OS.Next is to install SQL server.Then take backup and restore it on new server to create databases .

    Migrate logins and jobs using script method.There sre other methods using SSIS ,if you like you can use it

    Migrate packages if any.

    I guess this would be simple thing for you to do.Revert if you need any more help


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621MVP Monday, March 10, 2014 10:42 AM
    • Proposed as answer by Sofiya Li Tuesday, March 11, 2014 8:11 AM
    • Marked as answer by Sofiya Li Monday, March 17, 2014 1:52 AM
    • Unmarked as answer by imra-ebi Friday, May 16, 2014 1:16 AM
    • Marked as answer by imra-ebi Friday, May 16, 2014 1:16 AM
    Monday, March 10, 2014 10:38 AM

All replies

  • Check below article to migrate to new hyper-v host, if helps!!

    https://blogs.technet.com/b/keithmayer/archive/2012/09/13/migrating-to-microsoft-hyper-v-server-2012-from-2008-r2-and-vmware-winserv-hyperv-itpro-vmware.aspx


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Proposed as answer by Sofiya Li Tuesday, March 11, 2014 8:11 AM
    • Marked as answer by Sofiya Li Monday, March 17, 2014 1:52 AM
    Monday, March 10, 2014 5:10 AM
  • Hello,

    I dont think this is much of complex thing to do.You create a new box by installing win OS.Next is to install SQL server.Then take backup and restore it on new server to create databases .

    Migrate logins and jobs using script method.There sre other methods using SSIS ,if you like you can use it

    Migrate packages if any.

    I guess this would be simple thing for you to do.Revert if you need any more help


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621MVP Monday, March 10, 2014 10:42 AM
    • Proposed as answer by Sofiya Li Tuesday, March 11, 2014 8:11 AM
    • Marked as answer by Sofiya Li Monday, March 17, 2014 1:52 AM
    • Unmarked as answer by imra-ebi Friday, May 16, 2014 1:16 AM
    • Marked as answer by imra-ebi Friday, May 16, 2014 1:16 AM
    Monday, March 10, 2014 10:38 AM