SQL Server 2008 R2 Express on SBS 2008

Hi

I installed Sharepoint Foundation on SBS2008 along with SQL Express 2008, we are now hitting the 4GB limit.

I know I will eventually need to upgrade to SQL Express Standard but I need to "buy" some time.

QUESTION: can I upgrade SQL Server 2008 Express to SQL Server 2008 Express R2?
This will buy me 6Gb of time before I have to get a SQL standard version.

If I can, do you have a link to a decent walkthrough for me?

Thanks

Dave
LVL 1
davidfrankAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
elimesikaConnect With a Mentor Commented:
HI

As far as I see you will have to

1) backup your databases (or copy the *.mdf , *.ldf files to a separate backup location on your disk)
2)Un-install sql server
3) Install sql server 2008 R2

As Microsoft states , your old database files should work with the new version.
0
 
davidfrankAuthor Commented:
Thanks done just that!

Now using SQL 2008 R2 all working fine, ugrade took about an hour to run.

I am never sure how the integrated components within SBS will respond to these types of updates so thanks for you help.
0
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.

All Courses

From novice to tech pro — start learning today.