Entrar
 
HomeBibliotecaWikiAprenderGaleriaDownloadsSuporte ComunidadeFóruns
Recursos para Profissionais de TI >
> 
> 
SQL Server 2008 migration to new server.

Answered SQL Server 2008 migration to new server.

  • domingo, 13 de maio de 2012 04:02
     
     
    Entrar para Votar
    0

    Hello all.  I have been tasked with moving my SQL server 2008 to a new server, running Win Server 2008 on a Hyper V virtual Server.  The old server which will be decommishioned is also running on a Hyper V server, but is needed to be moved to a server with more resources.  I need to do this so when the server is brought online, it uses the same exact settings.  I will use the same server name and IP address on the new server as was used on the old one.  I must point out that I am not very schooled in SQL.  How can I do this so that it is seamless to the users.  I need to keep the old settings because people have queries mapped out to this server, my EDI settings are mapped out to it also.  Is this going to be a hard task?

    Thanks in advance

     

Todas as Respostas

  • domingo, 13 de maio de 2012 05:19
     
     Respondido
    Entrar para Votar
    0

    Hi,

    I think first you need to move your databases (By using attach/Deattach or backup and restore).

    Second you have to move your logins so all your users can log to your databases.

    Third you have to move your jobs.

    I hope this is helpful.

    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid

    MyBlog

     
  • domingo, 13 de maio de 2012 09:36
     
     
    Entrar para Votar
    0

    Hello all.  I have been tasked with moving my SQL server 2008 to a new server, running Win Server 2008 on a Hyper V virtual Server.  The old server which will be decommishioned is also running on a Hyper V server, but is needed to be moved to a server with more resources.  I need to do this so when the server is brought online, it uses the same exact settings.  I will use the same server name and IP address on the new server as was used on the old one.  I must point out that I am not very schooled in SQL.  How can I do this so that it is seamless to the users.  I need to keep the old settings because people have queries mapped out to this server, my EDI settings are mapped out to it also.  Is this going to be a hard task?

    is there any reason why you're not just moving the VM from the old Hyper-V server to the new Hyper-V server which is more powerful? That way you don't need to change anything on the SQL Server VM. After successfull move to the new server you can tune the SQL Server by adding more RAM, CPU etc. to get better performance.

    if you setup a new VM with latest OS and install SQL Server in this VM you need to transfer all the setttings like SQL Agent Jobs, Logins, etc.

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

     
  • domingo, 13 de maio de 2012 15:43
     
     
    Entrar para Votar
    0
    The old VM is out of space.
     
  • domingo, 13 de maio de 2012 16:13
     
     
    Entrar para Votar
    0
    The old VM is out of space.

    system partition only (c:) ?

    could you not enlarge the disk and how big is it ?

    if you've database files on this drive, move them to a different drive (via detach / attach)

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.