none
How to remove vmm-server

    Question

  • Hi folks,

    how can I remove an old VMM-Server?

    We have a new VMM-Server (not HA) and joined it to the existing DB.

    After that we want to remove the old one. We already uninstalled VMM machine manager app and console and hope we removed the old VMM-server. But it is still there.

    The only thing I found on the web is to remove some entries from the DB but is that the official way removing an old VMM-Server?

    What I found:

    check these tables

    [tbl_VMM_Server]

    [tbl_DR_VMMRegistrationDetails]

    [tbl_VMM_Server]

    Regads

    Thomas



    Wednesday, March 20, 2013 5:22 PM

Answers

  • To remove a VMM server, you must uninstall VMM server and select the option 'retain database'. Once this is done, you can install a new VMM server and connect to your existing database.

    -kn


    Kristian (Virtualization and some coffee: http://kristiannese.blogspot.com )

    Wednesday, March 27, 2013 6:50 AM
    Moderator

All replies

  • Hi Thomas,

    I had a similarly kind of issue, (one of my HVcould not be removed from the VMM console) I have solved this issue by removing some values into the VirtualMangeDB.

    1. Logon SCVMM server or the SQL server. (depending the location of the database)
    2. Open SQL Server Management Studio.
    3. Open the VMM database, default that is virtualManagerDB. Expand tables > open the table dbo.tbl_adhc_host and choose the option Edit Top 200 rows.

    4. Check names, you must find the missing computer name over there. Remember the HostID.
    5. You can try to remove the row but normally it has some references into the database that has to be removed first.

    I have wrote a blog article about my issue where I describe all the references. Please check: http://hyperv2012.wordpress.com/2013/03/19/how-to-solve-system-center-2012-sp1-issue-eventid-422-source-virtual-machine-manager/

    I hope this helps.

    Regards,

    Tristan


    Wednesday, March 20, 2013 8:19 PM
  • Tristan, thanks for reply.

    I´m not looking for removing a Hyper-V host.

    I looking for removing an old SCVMM-Server?

    Regards

    Thomas


    Saturday, March 23, 2013 8:00 PM
  • To remove a VMM server, you must uninstall VMM server and select the option 'retain database'. Once this is done, you can install a new VMM server and connect to your existing database.

    -kn


    Kristian (Virtualization and some coffee: http://kristiannese.blogspot.com )

    Wednesday, March 27, 2013 6:50 AM
    Moderator
  • The reason why I have two VMM Server listed under the Admin Console -> Fabric -> Infrastructure -> VMM server is that I already installed a new VMM server using a database backup (.bak file) from the old SCVMM. Having two VMM servers listed in that location, I am trying to find a way to remove the stale SCVMM. In this case, is your solution relevant?
    Tuesday, November 4, 2014 10:24 PM
  • I have the same issue in VMM 2016, 3 years on from your post.  Why on earth has MS no way to remove a VMM server that's no longer present WITHOUT digging around in the database.  I have left mine in place as my database is production and DO NOT WANT to hack with a production database.
    Thursday, January 11, 2018 1:15 PM
    1. Find out the old VMM server ID. Record the ServerID of the old VMM server.

    SELECT * FROM [VirtualManagerDB].[dbo].[tbl_VMM_Server]

    2.  Run the following to remove the old VMM server. Please replace the ID in the yellow part.

    EXEC prc_VMM_RemoveVmmServerById 'ServerID'


    Friday, April 6, 2018 2:34 AM
  • Worked like a charm.  Old VMM server has been removed! - Thankyou!

    This ability needs to be coded into the GUI!  Editing production databases is not ideal!

    • Edited by richsmif Tuesday, May 1, 2018 9:37 AM
    Tuesday, May 1, 2018 9:36 AM