SQL Server Primary file group max size

Question

Hello All!!!

I have a situation, I am trying to run almost 100 update statement on a table say 'XX'

In SQL Server database. But it is giving me an error tat goes something like this...

"Could not allocate space for object 'dbo.XX'.'PK_XX_3489AE06' in database 'MYDATABASE' 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."

Please advice me what to do... Thankx in advance

Answer 1

1. Check to see if your database has auto growth enabled.

2. Make sure you have available space on disk where your database file is located.