Post reply

Migration SQL Server 2005 from Physical Host to VM

  • June 25, 2015 at 11:59 am

    #318508

    Hello,

    it's my first time here, i need your help if you can 🙂

    So we have:

    (1) one physical server :

    OS : Windows Server 2003

    Active Directory, DNS, DHCP, File Server, Print Server and SQL Server 2005

    and we will install new (2) two server for High Availability with VMware vSphere (ESXi) 6.0

    and we will have (2) two Virtual Machine :

    1st VM :

    OS : Windows Server 2012 R2

    Active Directory, DNS, DHCP

    2nd VM :

    OS : Windows Server 2008 R2 (becaure SQL Server 2005 does not work with 2012 R2 😮 link)

    SQL Server 2005 Service Pack 3

    My Question is : What is a safe method to Migrate Database's from Physical Host (Windows Server 2003) to 2nd VM ?

    This is Schema description of what is want :

    Best Regards

  • June 25, 2015 at 3:04 pm

    #1808251

    Instead of converting the physical host to a VM it might be easier to setup a new instance of SQL Server and migrate the databases. That way if something does not work right you have a fallback. It also allows you to piecemeal the migration one db or app at a time.

    How to move databases between computers that are running SQL Server

    Joie Andrew
    "Since 1982"

  • June 25, 2015 at 7:10 pm

    #1808293

    Joie Andrew (6/25/2015)

    Instead of converting the physical host to a VM it might be easier to setup a new instance of SQL Server and migrate the databases. That way if something does not work right you have a fallback. It also allows you to piecemeal the migration one db or app at a time.

    How to move databases between computers that are running SQL Server

    Thank you very mutch for your fast answer smile

    i think, i will backup/restore database's one bye one smile

    However, you think i will not have a probleme with SQL Server 2005 SP3 on VM ? it's so old, but we can not upgrade to newest version $$$

    Best regards

  • June 25, 2015 at 11:54 pm

    #1808318

    I do not think you will have a problem with SQL Server 2005 on a VM. I have run 2005 instances on VMs; the software does not care (although I am not sure you will get the advantage of things like NUMA). I would not go to SP3 though. If you are going to stick with SQL Server 2005 it is probably more advisable to go up to the last patch level that was released.

    Joie Andrew
    "Since 1982"

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

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