Solved

SQL Server 2008 R2 Express on SBS 2008

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now