Solved

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

Posted on 2013-12-05
6
278 Views
Last Modified: 2013-12-10
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
Comment
Question by:IT_Group1
  • 3
  • 3
6 Comments
 
LVL 118
ID: 39698269
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
 

Author Comment

by:IT_Group1
ID: 39704316
Thanks, and what about the step-by-step instructions?
0
 
LVL 118
ID: 39704409
What would you like to do?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:IT_Group1
ID: 39705654
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
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 39705807
0
 

Author Closing Comment

by:IT_Group1
ID: 39708230
Thanks
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

914 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

23 Experts available now in Live!

Get 1:1 Help Now