Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2426
  • Last Modified:

'PRIMARY' filegroup is full error in SQL Express

I am using SQL Express 2005. I am accessing the database through an application that uses C#. When inserting records via my application, I am recieving an error message:

Could not allocate space for object 'abc' in database 'xyz' because the 'PRIMARY' filegroup is full.

There is plenty space left on the disk where the server is stored. That file size of the database is about 2 GB. The database is set to autogrow and unrestricted growth. What else can I be missing? The log file is not real big. All of the things that I have seen that cause this problem are not an issue with the database server. Any suggestions? Thanks in advance.
0
lmred
Asked:
lmred
  • 6
  • 5
  • 4
  • +1
1 Solution
 
regbesCommented:
Hi crchisholm,

if no one can help

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please try to add a second datafile to the primary filegroup.
0
 
regbesCommented:
lmred,

AFIK the limit for SQL express databases is 2GB if you need more than this you will have to up grade to SQL standard ED

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
lmredAuthor Commented:
The limit for MSDE is 2 GB, for Sql Express its 4 GB.
0
 
regbesCommented:
lmred,

correction it is 4GB

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

your best bet is angels advice
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
ie, I guess that your filesystem's limit is at 2GB per file
0
 
NightmanCTOCommented:
Is your hard drive formatted as FAT32 or NTFS?
0
 
lmredAuthor Commented:
The second data file sounds like a great idea. I never thought of that. Somebody is currently working on the server. When he finishes, I am going to try that idea.

Let me tell you something guys....you are sure fast with your responses. I don't think I've ever been in another section before that responds this fast. Thanks guys!!! If anybody else can think of another idea until I can check the second data file option, please let me know.
0
 
lmredAuthor Commented:
I think its NTFS, but I will have to check after the guy gets off the server.
0
 
lmredAuthor Commented:
Ok guys. I found out what the problem is. Duh! SQL Express is installed on the server. However, the database I am using is an MSDE database. So it's hitting the 2 GB limit.

Now how should I go about accepting the right answer?
0
 
NightmanCTOCommented:
Are you restoring the MSDE database to SQL Express? Or accessing it on an MSDE instance? I have never heard of the limitation after an upgrade - doesn't mean it can't happen, just that I have never heard of it ;)

As for right answer - well, you can always split.
0
 
lmredAuthor Commented:
I attached the MSDE database to the SQL Express instance. There is a limit on SQL Express whether you attach or create a new database.
0
 
NightmanCTOCommented:
Except as already noted the limit on SQL Express is 4GB, not 2GB. So this should not be an issue.
0
 
lmredAuthor Commented:
Originally the database was actually MSDE database. I thought it was SQL Expresss since SQL Express was installed on the server. When I realized this, I attached the MSDE db to SQL Express and there was no longer an issue.
0
 
NightmanCTOCommented:
Oh, OK - sorry. I thought you were having the problem with a backed up MSDE on a SQL Express instance, which made no sense. And since this wasn't the case, that explains why I was confused ;)
0
 
regbesCommented:
Hi Scripter25,

Import SSIS and DTS type operations are not supported in Express

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

save the spreadsheet to a .csv

then use BCP or bulkinsert to get the data in


HTH

R.
0
 
regbesCommented:
Sorry guys im having a bad time posting answers to the wrong questions
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 5
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now