Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • 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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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