vcenter server database path

is there anywhere within vcenter server application to show exactly where the underlying sql database resides (i.e. path). can you provide a screenshot on where in vc we could find this information..
LVL 3
pma111Asked:
Who is Participating?
 
Alex GreenConnect With a Mentor 3rd Line Server SupportCommented:
You can't from the client however if you log onto your V-Center server and then check the ODBC connections, you can see the server and the instance that it's using.

Regards

Alex
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
On the vCenter Server, you will be able to show and tell where the ODBC reference is to the SQL Server and Database. But it will not show the physical path to the actual SQL database.

This is the ODBC Reference

ODBC Reference
You would need to view the SQL Database in Management Studio, to find the path to the actual database.

database
The above shows the Database Server, which is localhost (the same server vCenter Server is installed on!)

and the database name is VIM_SQLEXP
0
 
pma111Author Commented:
by default will sql express be installed on the same server as the vcenter application, i.e. is that default for the installation of the product? or can an admin move the database to any server they chose?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Alex Green3rd Line Server SupportCommented:
You can move it to any database or server you choose to

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1028601

Full step by step guide there to move it to a full fat SQL2008 server
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
By Default vCenter Server installation can and will use SQL Express, unless you specify another SQL server.

The database can be moved, from SQL Express to Full version of Express.

But now that SQL Express can handle much larger databases, it's not often done anymore.
0
 
Alex Green3rd Line Server SupportCommented:
however running backups on express is a pain since it doesn't entirely support backups. It can be done but it's a pain.

https://support.microsoft.com/kb/2019698

Therefore people elect to go for a full SQL server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.