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 ...
15th October 2010, 12:30 PM #1
SQL Server Migrations
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).
24th October 2010, 05:38 PM #2
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
25th October 2010, 01:00 PM #3
you would have to create a new SharePoint/WSS farm as you can't move the sharepoint database from express to full SQL.
By apearce in forum Virtual Learning Platforms
Last Post: 11th October 2011, 05:34 PM
By localzuk in forum MIS Systems
Last Post: 21st June 2010, 11:46 AM
By DSapseid in forum Windows
Last Post: 18th May 2009, 01:48 PM
By wesleyw in forum Windows
Last Post: 28th June 2006, 09:42 AM
By chrbb in forum Windows
Last Post: 19th January 2006, 12:23 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)