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.
- Run Regedit
- Browse to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
- 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>“