Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

2008 SQL Server Express size limit and how to upgrade to 2008 SQL Express R2

Posted on 2014-12-08
11
Medium Priority
?
99 Views
Last Modified: 2015-04-26
Trying to upgrade an application I have from one version to another and I'm getting a message about the database not having enough space to do the upgrade.  Currently, the database is only 2.5GB...

I thought I had downloaded the 2008 R2 SQL express to give me a 10GB database size limit...Can someone help me with this?
0
Comment
Question by:vianceadmin
[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
  • 5
  • 5
11 Comments
 
LVL 11

Expert Comment

by:Ray
ID: 40487837
There may be a disk space issue as sql server 2008 express (non R2) supports 10GB files.  

There could also be an issue with DB compatibility level.  SQL Server 2008 may not allow the 10GB limit if the DB itself is in a compatibility mode prior to 2008.  If this is the issue, you can change the "compatibility level" by going to the object browser and right click on the database name, then select properties.  In the next window, select 'options' on the left and "compatibility level" on the right then set to 2008 if not already there.  Be sure that compatibility level will not cause any grief with applications that access the data.
Capture.PNG
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40488396
Did you check how much available space do you have in the disk where you want to install the SQL Server?
0
 

Author Comment

by:vianceadmin
ID: 40488907
Compatibility level is set to SQL Server 2005 (90).  Is that the issue?  I can change it to SQL Server 2008 (100).  Plenty of space on the disk...
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40488913
Yes, you can try,
0
 

Author Comment

by:vianceadmin
ID: 40589589
Apparently there was a way to do the upgrade of the app and not care about the size of the database.
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40590497
Do you want to share with us the solution?
0
 

Accepted Solution

by:
vianceadmin earned 0 total points
ID: 40590871
Apparently there was space on the database but the install of the app was checking something. I called them and they had me run the install with a parameter that ignored the size of the database.
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40590880
Thanks.
0
 

Author Comment

by:vianceadmin
ID: 40734410
Request to close case...
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40735104
Chose your comment as solution. Should be enough to close this question.
0
 

Author Closing Comment

by:vianceadmin
ID: 40744664
Found own solution...
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

610 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