Results 1 to 5 of 5

Thread: Move SCVMM 2008 R2 Database To Other SQL Server

  1. #1
    Join Date
    Jan 2010
    Posts
    62

    Move SCVMM 2008 R2 Database To Other SQL Server

    Hello, I want to move my SCVMM 2008 R2 Database To Other SQL Server, I am not able to get the solution for this. If you are having any details about it, then please provide that to me. I will be thankful to you. If you are having any details about it or if you are having any suggestions on this then please provide that to me.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,642

    Re: Move SCVMM 2008 R2 Database To Other SQL Server

    Hello, you need to follow the steps below:
    • First take backup of the SQL database VirtualManagerDB
    • Then you can simply restore that database to the new SQL server.
    • Now it is necessary to take your older database to the offline.
    • Now you can simply change the registry key with the help of key below:
      HKLM\SOFTWARE\Microsoft\Microsoft System Center Virtual Machine Manager Server\Settings\Sql
    • Now it is necessary to change the "Connection String" if you want to use the new server.
    • Then also change the "Machine Name".
    • Now simply stop and restart the Virtual Machine Server service.
    • Done.

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: Move SCVMM 2008 R2 Database To Other SQL Server

    Hello, I am also searching for the same solution. I have tried to make use of the internet for getting the solution for my problem, but I am not able to get the solution for it. If you are having any kind of solution then please provide that to me. I have tried to search this on the different sites and followed some of the steps, but none of them work for me. So, if you provide me some useful steps then I can solve my problem.

  4. #4
    Join Date
    May 2008
    Posts
    4,570

    Re: Move SCVMM 2008 R2 Database To Other SQL Server

    Hello, I have come to know the following details from which you can simply Move SCVMM 2008 R2 Database To Other SQL Server. So, use the steps below:
    • Take backup of the database from the SCVMM admin console
    • Now simply copy and paste that file to the new SQL Server
    • Now you need to tried to recover using the SCVMMRecover.exe.

  5. #5
    Join Date
    May 2008
    Posts
    4,831

    Re: Move SCVMM 2008 R2 Database To Other SQL Server

    Hello, for moving the SCVMM 2008 R2 Database To Other SQL Server you must need to follow the steps below :
    • First create a backup for your VMM DB
    • After taking backup you need to remove the VMM with the option of Retain Data.
    • Now on your remote SQL server simply get that VMM db.
    • Now you need to install the VMM on the new server and with the help of the VMM db.
    • If the managed host get the Access Denied as a status then simply right click on it and simply select the Reassociate.

Similar Threads

  1. how to move WINS from server 2003 to server 2008
    By Imran in forum Windows Server Help
    Replies: 3
    Last Post: 09-01-2014, 01:42 PM
  2. Replies: 1
    Last Post: 16-08-2011, 02:36 PM
  3. Database mirroring on sql server 2008
    By Meditation in forum Software Development
    Replies: 4
    Last Post: 01-02-2011, 10:11 AM
  4. How to Move WSUS Database From Windows Server 2003 to 2008
    By Samarth in forum Server Update Service
    Replies: 3
    Last Post: 23-10-2009, 02:23 PM
  5. Windows Server 2008 can not move OU
    By techcoor in forum Windows Server Help
    Replies: 9
    Last Post: 17-04-2009, 04:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,712,992.23772 seconds with 17 queries