Solved

SQL Server 2008 R2 Express on SBS 2008

Posted on 2010-11-09
2
717 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:davidfrank
2 Comments
 
LVL 19

Accepted Solution

by:
elimesika earned 250 total points
ID: 34096554
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
 
LVL 1

Author Comment

by:davidfrank
ID: 34100667
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question