sql server - Could not allocate a new page for database because of insufficient disk space in filegroup -
I am getting this error in the log when running a program in SAS included in SQL Server 2008:
Execute Error: ICommand :: Execute Failed. : The statement has been terminated: Due to insufficient disk space in the file group 'CURRENT01', a new page could not be allocated for the database 'databse'. Make the necessary space by excluding objects in the file group, adding additional files to the file group, or setting the autogrowth for the existing files in the file group.
I am looking for similar problems and I can not really see the solution. I am pretty sure there is enough room in our database. Can this be anything related to the work? I am quite new to SQL Server
For your help, thanks in advance,
Check the settings for the data file in that file group. Most likely that the upper limit of their upper limit has been fulfilled, where you have an empty space, no matter what the situation is.
You can find these settings from the management studio: Click Database -> Properties -> Files -> Columns Autograph / Maximum Size.
You should also check that the database files are on the disk drive where you expect them to.
Comments
Post a Comment