VMware Cloud Community
tippet5x
Enthusiast
Enthusiast
Jump to solution

Locate SQL

How can I tell what version of SQL and where the database is?

need to backup it up before an upgrade

thank you

Reply
0 Kudos
1 Solution

Accepted Solutions
JPM300
Commander
Commander
Jump to solution

On your vCenter server go into Control Panel > Administrator Tools > ODBC

Under the DSN tab you will see some ODBC connections to the name of your SQL server and it will even tell you the name of the Database.

If you vCenter is an appaliance look in your appliance settings and you will see something simular.

If you run UpdateManager on  your vCenter Server it will probably also have an ODBC to your Update Manager Database there as well.

Hope this has helped

View solution in original post

Reply
0 Kudos
1 Reply
JPM300
Commander
Commander
Jump to solution

On your vCenter server go into Control Panel > Administrator Tools > ODBC

Under the DSN tab you will see some ODBC connections to the name of your SQL server and it will even tell you the name of the Database.

If you vCenter is an appaliance look in your appliance settings and you will see something simular.

If you run UpdateManager on  your vCenter Server it will probably also have an ODBC to your Update Manager Database there as well.

Hope this has helped

Reply
0 Kudos