CODEWITHSUNDEEP
sql-server-2008
gruber
gruber

Reputation: 29737

Problem with disk space sql server 2008

Im executing query but there is an error:

Could not allocate space for object 'dbo.User2User'.'IX_User2Id' in database 'MyDatabase' because the 'PRIMARY' filegroup is full.

Is enabled autogrowth by 10 MB without any restrictions on size.

Thanks for any ideas how to cope with that

Upvotes: 0

Views: 383

Answers (1)

codingbadger
codingbadger

Reputation: 43984

If this physical disk is not full and you are sure that you have restricted the file size within SQL then I would imagine that you are using Express version.

Express Version has a 10GB Database limit.

Compare SQL Editions

Upvotes: 1

Related Questions