Solved

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

Posted on 2014-12-08
11
58 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
  • 5
  • 5
11 Comments
 
LVL 10

Expert Comment

by:Ray
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
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
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Yes, you can try,
0
 

Author Comment

by:vianceadmin
Comment Utility
Apparently there was a way to do the upgrade of the app and not care about the size of the database.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 45

Expert Comment

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

Accepted Solution

by:
vianceadmin earned 0 total points
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Thanks.
0
 

Author Comment

by:vianceadmin
Comment Utility
Request to close case...
0
 
LVL 45

Expert Comment

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

Author Closing Comment

by:vianceadmin
Comment Utility
Found own solution...
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 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

7 Experts available now in Live!

Get 1:1 Help Now