Solved

SQL Server 2008 R2 Express on SBS 2008

Posted on 2010-11-09
2
715 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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.

810 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