Solved

vcenter server database path

Posted on 2014-02-05
6
2,144 Views
Last Modified: 2014-02-05
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..
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 11

Accepted Solution

by:
Alex Green earned 250 total points
ID: 39835249
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
 
LVL 120

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 39835251
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
 
LVL 3

Author Comment

by:pma111
ID: 39835255
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
2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

 
LVL 11

Expert Comment

by:Alex Green
ID: 39835257
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
 
LVL 120
ID: 39835260
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
 
LVL 11

Expert Comment

by:Alex Green
ID: 39835264
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

Featured Post

Put Machine Learning to Work--Protect Your Clients

Machine learning means Smarter Cybersecurity™ Solutions.
As technology continues to advance, managing and analyzing massive data sets just can’t be accomplished by humans alone. It requires huge amounts of memory and storage, as well as the high-speed power of the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question