Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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
0
IT_Group1
Asked:
IT_Group1
  • 3
  • 3
1 Solution
 
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
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
What would you like to do?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
0
 
IT_Group1Author Commented:
Thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now