Last week a user asked my help on this error. After helping him, I thought it would be a good idea if I can post more detailed steps as a blog.
What is the issue?
You receive an error message “Could not allocate space for object dbo.final in database LSWB because the ‘PRIMARY’ filegroup is full. contd….. ” as shown in below pic. You see this error message if you are actively running a transaction from a query window in SSMS or you would see an entry in SQL Server Error Log.
What this error means is, the filegroup mentioned in the error message is full and no more free space is available in the data file(s) of that filegroup. The database objects which need additional space to grow (to add new data) cannot grow causing failure to add new data or if new database object(s) are to be created, that cannot happen due to lack of free space in the filegroup.
Why does this happen?
There might be multiple reasons that cause this problem. Some of them are..
How to solve this?
I order to solve this problem, there are few solutions and which one of the solutions can be applied depends on one or more factors on your SQL Server where this error has occurred.
Note: Pay attention when doing either of the last 3 steps, make sure that file(s) are not required (if deleting) or the database you shrink has sufficient free space in itself to survive until you get more oxygen (new storage attached to the server) or the table(s) or Indexes you drop in the same file group are not required any more…
Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.
– Bru Medishetty