Thin Client and Virtual Machines Thread, vmware SQL database in Technical; Does anybody know which would be the best database format for running 4 hosts and about 20 vm's? The vmware ...
13th February 2009, 08:58 AM #1
vmware SQL database
Does anybody know which would be the best database format for running 4 hosts and about 20 vm's? The vmware manuels say that SQL 2005 express will only support 5 hosts and 5 virtual machines, I'm sure that I read on the vm site that it was 5 hosts and 50 virtual machines. Should I even use SQL 2005 express or just go for SQL 2005 standard edition?
IDG Tech News
13th February 2009, 09:06 AM #2
Its 5 hosts and 50VMs for the sql express version with VC2.5.
"Note VMware recommends Microsoft SQL Server 2005 Express for small deployments only (up to 5 hosts and 50 virtual machines)."
This is down to a 4GB limit to the database.... I'm not sure if this is a phyical limit or a 'suggested limit' as the database size predictor doesnt get near 4gb with 5 hosts and 100 guests.
I've just setup 4 hosts (bl480c), seperate VC box (rm dualsrv) with sql express. Apparently its not hard to migrate to a full SQL install if you want to support more VMs (like VDI (view)).
Moving SQL database:
Last edited by Theblacksheep; 14th February 2009 at 01:47 PM.
2 Thanks to Theblacksheep:
badders (13th February 2009), ranj (22nd February 2009)
22nd February 2009, 10:26 AM #3
Great thread, a question I had was if it I wanted to move the database from one server to another, if this could be done. It seems like it is possible.
29th September 2010, 11:45 AM #4
I got a question about the SQL database which vcenter uses.
We have an issue at the moment where from a client we were not able to login to the vcenter server, this was because the vcenter server service was going to a stopped state.
VMware support told me it was because the database was growing in size and once we ran a backup it seemed to have resolved the problem.
We are in a similar situation where we only have 3 hosts so dont need a full blown SQL server so have been using SQL express with management studio express.
Through this I can do one off backups but it means I need to remember to do them.
Is anyone else using SQL express with vcenter and able to do scheduled backups.
I am not very good with backup scripts. Has anyone got one that I could borrow? The VMware guy said I could use Transact SQL to do scheduled backups??? He wasn't able to talk me through with this though.
Any tips would be greatly appreciated.
29th September 2010, 12:14 PM #5
Have a look at this:
Scheduled backups for SQL 2005 Express
Just tried it on our vcenter and seems to do the job.
I ignored step 1 and just clicked on script on the Back Up Database page, then saved the script out to the desktop.
Last edited by badders; 29th September 2010 at 12:18 PM.
Thanks to badders from:
ranj (29th September 2010)
29th September 2010, 02:26 PM #6
Yes I can confirm this works. Thanks!
Originally Posted by badders
Last Post: 18th December 2007, 03:31 PM
By Mr_M_Cox in forum MIS Systems
Last Post: 16th August 2007, 03:24 PM
Last Post: 26th February 2007, 09:11 PM
Last Post: 8th June 2006, 09:36 PM
By Frazer in forum MIS Systems
Last Post: 28th March 2006, 12:15 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)