December 16, 2022 at 8:49 am
Hi Experts,
I have a database with multiple files on multiple drives and one of the drive is restricted to a defined size. Now because the index maintenance job is failing with below error. How can I rectify this without increase the disk space.
Could not allocate space for object 'dbo.Table1'.'PK_Table1_ID' in database 'DB1' 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.
Could not allocate space for object 'dbo.tABLE2'.'Uk_id' in database 'DB1' 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.
December 16, 2022 at 1:14 pm
Create a file group in a different location and move those indexes to that file group.
"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
December 16, 2022 at 7:10 pm
Add a new volume - either as a mount point or a separate drive. Add a new file to the PRIMARY filegroup at the same size as the exiting file(s) for the primary group.
Index rebuilds will then - over time, balance the data across both files.
Or - do as Grant suggested.
Or - archive and purge data from the current tables to make space available.
Or - enable page compression.
Or - all of the above.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply