Update statistics job error

Question

Update statistics job error

tt-615680

SSCertifiable

Points: 7835
More actions
January 7, 2014 at 1:53 am

#281761

Dear All,
I keep getting the following error message when trying to run the update statistics job; I wanted to know what would be the best approach as it is a critical server please?
“failed with the following error: "Could not allocate space for object 'dbo.'databasename'.'PK_'''''''' in database 'databasename' 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.".
Thank you in advance!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

I'd recommend expanding existing files or adding a file to the primary file group so that it has enough room to get the work done.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

Thinking about it some more, it's also possible you need space in tempdb.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

tt-615680 SSCertifiable Points: 7835 More actions · Answer 3

The space of the tempdb is = 229498.81 MB and the available space is 215296.58 MB at the moment so no it doesn't look as if there is enough space left.

The autogrowth on the database is by 100mb, unrestricted growth on the Primary file and by 10mb, unrestricted growth on the lof file. I'm not sure if the setting are done properly?

Lowell SSC Guru Points: 323518 More actions · Answer 4

just had the same issue on a database hosted on a web server.

the database was limited to 250 meg, and not allowed to auto grow.

check the properties of the database, as well as the other suggestions:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!