+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1
    badders's Avatar
    Join Date
    Apr 2007
    Location
    Cumbria
    Posts
    170
    Thank Post
    44
    Thanked 11 Times in 10 Posts
    Rep Power
    21

    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?

  2. #2

    Theblacksheep's Avatar
    Join Date
    Feb 2008
    Location
    In a house.
    Posts
    1,918
    Thank Post
    131
    Thanked 287 Times in 208 Posts
    Rep Power
    193
    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)."

    http://pubs.vmware.com/vi35/install/...ed_vi.8.6.html

    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:
    http://www.amikkelsen.com/files/docu...Ltoanother.pdf
    Last edited by Theblacksheep; 14th February 2009 at 01:47 PM.

  3. 2 Thanks to Theblacksheep:

    badders (13th February 2009), ranj (22nd February 2009)

  4. #3
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    728
    Thank Post
    98
    Thanked 42 Times in 32 Posts
    Rep Power
    25
    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.

  5. #4
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    728
    Thank Post
    98
    Thanked 42 Times in 32 Posts
    Rep Power
    25
    Hi sorry
    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.

  6. #5
    badders's Avatar
    Join Date
    Apr 2007
    Location
    Cumbria
    Posts
    170
    Thank Post
    44
    Thanked 11 Times in 10 Posts
    Rep Power
    21
    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.

  7. Thanks to badders from:

    ranj (29th September 2010)

  8. #6
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    728
    Thank Post
    98
    Thanked 42 Times in 32 Posts
    Rep Power
    25
    Quote Originally Posted by badders View Post
    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.
    Yes I can confirm this works. Thanks!

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 18th December 2007, 03:31 PM
  2. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 03:24 PM
  3. Replies: 2
    Last Post: 26th February 2007, 09:11 PM
  4. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM
  5. Replies: 2
    Last Post: 28th March 2006, 12:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •