Solved

SQL Server 2008 R2 Express on SBS 2008

Posted on 2010-11-09
2
719 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint 2016 LDAP connection 22 91
How to prevent Reservation conflict in SharePoint 2013? 2 30
SQL profiler 3 51
T-SQL: How to extract records into a new table 7 44
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...

759 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