I have a clustered SQL instance (version SQL2008 SP1 CU5) ; database size >1TB; there is a partitioned table with total size 50MB and a maintenance job to re-organize index on one partition of this table. script as below:
ALTER INDEX [PK_MyTable] ON [dbo].[MyTable] REORGANIZE PARTITION=95
SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() AS ErrorState, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_LINE() AS ErrorLine, ERROR_MESSAGE() AS ErrorMessage
then I got error msg:
Error: 1105, Severity: 17, State: 2.
Could not allocate space for object 'dbo'.'MyTable' in database 'MyDB' because the 'Data3' 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.
I have 36 files on filegroup Data3; 28 files are full without autogrowth; 4 files have autogrowth=100MB and almost reach max size; last 4 files have autogrowth=100MB and far from max size; all these 8 files have enough space to grow on disk. Log file =128GB
and was almost empty.
there was no backup db/log activity when error popped up.
I have no clue how could this error happened. Can any one help?
View Complete Post