Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a local project i am working on, on my own workstation. I am using a local instance of SQL Server Express.

The project contains a lot of data, and as of now, I just need to be able to store all this data in the SQL db. The main PRIMARY file is, as of now, in the size of 9,5 GB.

I keep getting the error "Could not allocate space for object 'dbo.History' in database '[path to mdf]' because the 'PRIMARY' filegroup is full". I then tried fiddling with the autogrowth properties (default was "By 10 percent, unrestricted growth". I have around 60gb free on the disk. I then tried setting it to "By 50000 mb, unrestricted growth", and adding 4 more primary files - but I still get the same error?

What can I do - I am not really to concerned about how and why the db is so large, i just want the SQL server to accommodate the size of the files.


migration rejected from Mar 30 at 18:04

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, Erik, RolandoMySQLDBA, RLF, mustaccio Mar 30 at 18:04

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Erik, RolandoMySQLDBA, RLF, mustaccio
If this question can be reworded to fit the rules in the help center, please edit the question.

Forgot to mention that i am running SQL Server Express 2008 R2. And i just found a post saying "SQL Server Express 2008 R2 is limited to 10GB.". So it looks like this could be where the error is. Hmm - is there no way around this or what could be a solution for me? – brother Jul 17 '12 at 11:34
On Express you cannot grow the database. For development you can buy a licensed Developer Edition which is unrestricted and costs about $50. – Remus Rusanu Jul 17 '12 at 11:39
As your own comment has stated, you have reached the max size of the database. You have one of two options as far as I see it: 1. Upgrade your edition 2. Design your application so that it uses multiple databases therefore working around your size limit – Thomas Stringer Jul 17 '12 at 12:32
The issue is indeed the Express version being capped. However, your question states that you are worried about how or why the database is so large. That's something only you can answer. You could consider archiving data into a seperate database (i.e. data > 3 months), but that would probably require a lot of custom coding, and you already did state that you need to be able to store all the data. – user569711 Jul 17 '12 at 12:35
@brother -- out of curiosity unrelated to your question, does dbo.History contain two ntext fields? – EngineeringSQL Mar 4 '13 at 20:57