View Only
  • 1.  VCDB location

    Posted Oct 04, 2011 04:24 PM

    So I have a completely stupid problem, I had to rebuild my VC a while back and decided to give it a clean database but left hte old database up while I transfered all the hosts and such to the new server.  I then forgot to delete the old database so now I have a VCDB and a VCDB4 but I'm not exactly sure which one is being used by my current server.

    I've tried to look at the access to the databases but it seems like jobs are still running on both of them.  Is there an easy way to look at the odbc connection or a setting to see what database is being pointed to?


  • 2.  RE: VCDB location

    Posted Oct 04, 2011 04:48 PM

    Hey Kyle,

    Open the Data sources (ODBC) and get the system DSN Name.  Browse to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ and find the DSN listed there and then look at the Database key. This is the name of the database the DSN is pointing to.

    Good Luck!

  • 3.  RE: VCDB location

    Posted Oct 04, 2011 04:52 PM

    I got a whole lotta nothing under the ODBC path within the registry.  Any other ideas?

  • 4.  RE: VCDB location
    Best Answer

    Posted Oct 04, 2011 04:58 PM

    Lots of ideas....

    Try, HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc.\VMware VirtualCenter\DB

  • 5.  RE: VCDB location

    Posted Oct 04, 2011 05:09 PM

    And thank you. Now to find a time to take the other DB offline and hope that the information in the reg is correct!

  • 6.  RE: VCDB location

    Posted Oct 04, 2011 05:13 PM

    Haha - me too. I would shut down the vCenter services first and then offline that db and try to bring vCenter back up. If you chose correctly, you are good. If not, you just need to swap the DBs and try again - nothing should be broken.