Solved

vcenter server database path

Posted on 2014-02-05
6
1,894 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
  • 3
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
alexgreen312 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 118

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 6

Expert Comment

by:alexgreen312
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 118
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 6

Expert Comment

by:alexgreen312
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Teach the user how to install and configure the vCenter Orchestrator virtual appliance Open vSphere Web Client: Deploy vCenter Orchestrator virtual appliance OVA file: Verify vCenter Orchestrator virtual appliance boots successfully: Connect to the …

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now