Where is My VCenter Database Located?

If you are performing an upgrade of your VCenter it is a good idea to understand where the Database for the VCenter is before any upgrade. This will enable you to plan any pre-requisite tasks such as backing up the server or snapshotting it etc. Obviously we have to possibilities here, a local DB or a SQL based DB.

To locate the DB we can used the following process.

  1. Run Regedit
  2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
  3. Locate the Server DWORD

If the value = “.” then the database is local, other wise the value will be the SQL server path for example “sqlserver://<server name>;databaseName=<database name>“

Tags: Vcenter

Allen White

Allen is an IT Consultant and holds the following accreditations. MCSA, MCSE, MCTS, MCITP, CCA, CCSP, VCP 4,5, 6 and HP ASE, AIS - Network Infrastructure.

Leave a comment

Categories

Vote!

What Web Browser Do You Use?

View Results

Loading ... Loading ...

Vote!

What do you prefer..VMware or Hyper-V?

View Results

Loading ... Loading ...