SQL Express 2005 upgrade on SBS 2008 with WSUS

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
grimpexAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason CrawfordExchange / Office 365 Premier Field EngineerCommented:
You can't upgrade the 32-bit version to 64-bit,  but it will install in the 32-bit subsystem of a 64-bit server:

https://technet.microsoft.com/en-us/library/ms143393(SQL.90).aspx

Don't try to remove WSUS.  Just pretend you don't see it.

Just backup your 2005 database, install a separate 2008 R2 instance, and restore the database to the new instance, no?
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
grimpexAuthor Commented:
Thanks !

I think this may just be the way - however I do need to do something about WSUS database - eating up 40Gb in space.
0
Cris HannaCommented:
Have you run the WSUS clean up utility?   That will help reduce the WSUS database size
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Peter HutchisonSenior Network Systems SpecialistCommented:
You can turn off the downloads from Microsoftand remove any Group Policies that use WSUS to stop if from collecting information from user PCs.
0
grimpexAuthor Commented:
so far moved WSUS database and store to another volume

decided to install 2012 SP1

next to restore from backup - hope this will go well

then reconnect clients via ODBC on windows 7
0
Jason CrawfordExchange / Office 365 Premier Field EngineerCommented:
Via con Dios amigo.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.