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?
 
Andrew Hancock (VMware vExpert / EE MVE^2)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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
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.