+ Post New Thread
Results 1 to 3 of 3
Windows Server 2008 R2 Thread, SQL Server Migrations in Technical; Hi all, Right now we have a number of instances of SQL Express (mainly 2008) running on various servers and ...
  1. #1
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,207
    Thank Post
    137
    Thanked 345 Times in 291 Posts
    Rep Power
    87

    SQL Server Migrations

    Hi all,

    Right now we have a number of instances of SQL Express (mainly 2008) running on various servers and I was wondering if we would see any benifits from consolidating all those instances onto a single server?

    Currently SQL runs our SharePoint server, Libary system, SCVMM and WSUS (maybe a few other little things).

    If there would be an advantage the SQL Server would be hosted on our Virtual Server with whatever RAM/Processor allocation required (that shouldn't be tooo much of a problem unless I need to go over 2-4GB RAM).

    Thanks!

  2. #2
    kevin_lane's Avatar
    Join Date
    Mar 2007
    Location
    Derby
    Posts
    514
    Thank Post
    26
    Thanked 21 Times in 21 Posts
    Blog Entries
    5
    Rep Power
    20
    i my self was thinking consolidating my sql servers into one but from the advise i got it wasn't recommend because the way sql is with regards to memory hungry i went to a conf a few weeks back where Microsoft was virtualizing sql servers and it seemed all ok but you need to think of the risk with everything being on one box i think your going to at least need a min of 8 to 16 gig of memory i might be wrong but then again i don't know what sort of setup you have and how big you are

  3. #3
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    417
    Thank Post
    36
    Thanked 176 Times in 111 Posts
    Rep Power
    43
    you would have to create a new SharePoint/WSS farm as you can't move the sharepoint database from express to full SQL.

    A.

SHARE:
+ Post New Thread

Similar Threads

  1. Installing Moodle on Windows Server, SQL Server, IIS
    By apearce in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 11th October 2011, 04:34 PM
  2. Replies: 5
    Last Post: 21st June 2010, 10:46 AM
  3. SQL Server
    By DSapseid in forum Windows
    Replies: 1
    Last Post: 18th May 2009, 12:48 PM
  4. SQL Server
    By wesleyw in forum Windows
    Replies: 5
    Last Post: 28th June 2006, 08:42 AM
  5. sql server
    By chrbb in forum Windows
    Replies: 17
    Last Post: 18th January 2006, 11:23 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
  •