SQL 2008 std for Virtual center DB - a step by step guide

Guys,

We're always running out of space in our Virtual Center (VC) SQL express.
We do have an enterprise license for version 4 + 5, so i wish to install a full SQL on the same VM as the VC and use it as our DB with more space than the default 4GB.

Please provide me a step by step guide for this procedure.
In adition, should I uninstall SQL express from the VC?
Is it a best practice to install the full SQL std 2008 on the same VM as the VC?

Thanks in advance
IT_Group1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I would recommend a new dedicated server for Full SQL for vCenter Database.

Or if budget sensitive ensure you give vCenter Server plenty of RAM eg 16GB
0
 
IT_Group1Author Commented:
Thanks, and what about the step-by-step instructions?
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
What would you like to do?
0
 
IT_Group1Author Commented:
Import from existing SQL express to full SQL --OR-- installing a fresh SQL std x64 (2008 R2), on the same VC VM and connecting the VM DB to the new installation.

I don't care much about the existing data in the DB, but i prefer to keep it if it's possible.

TNX in advance
0
 
IT_Group1Author Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.