CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2008
user1991508
user1991508

Reputation: 153

SQL Server 2008 error - cannot allocate space for object

I'm using SQL Server 2008 Express.

The properties of my database say the DB size is 4GB.

My DB has 2 main tables, each with about 2GB.

I'm getting the following Error when I try to insert a new record:

[Microsoft][ODBC SQL Server Driver][SQL Server]
Could not allocate space for object 'dbo.Futures_Tick'.'IX_Futures_Tick' in database 'Prices_Live' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

I'm not sure what to do. I don't see how to free up space in the primary filegroup as the error message is telling me (I'm not even sure what the primary filegroup is).

I'm a little new to DB admin things... I just know the basic SQL commands (Insert, Update, Delete).

help??

Upvotes: 1

Views: 2138

Answers (1)

jpw
jpw

Reputation: 44871

Pretty sure SQL Server 2008 Express is limited to max 4 GB databases. You need to upgrade to 2008R2 or later to overcome it. As 2012 is the most recent that should be the best option unless you have legacy code.

Find it here: 2012 Express Edition. And here is the supported upgrade paths.

As @marc_s pointed out in a comment, this version is still limited to 10 GB, so you might want to look into the the paid version if you demand more.

Upvotes: 2

Related Questions