Hello :) advice needed and appreciated !
3rd party application has outgrown the 4Gb database limit - small network 8 users. The app utilises SQL express - currently 2005 x86 version
Plan to upgrade to SQL express 2008 R2 and IDEALLY - in place upgrade
However this will also upgrade the SBS SQL which runs WSUS [ we do not use WSUS and ideally would want to get rid off it all together - not sure how to safely do that without breaking the SBS ]
SBS is really used as file and print server with SQL function for the 3rd party database
Really keen on in place upgrade and will I mess things up ?
Is there any point to move to 64bit and would inplace support upgrade from 32bit to 64bit ?
Any relevant info and what to avoid appreciated !
If inplace does not work then I have all the clients to connect to the server all over again
OR would installing another instance of SQL Express 2008 R2 make sense ? but then surely consuming more resources ?
Have ordered 24Gb of 1600Mhz DDR3 RAM just in case - at present the 8Gb is peaking all the time, SQL eating 3Gb on average at present.
THANK YOU ! need answer by tomorrow 13:00GMT