SQL Server Performance Forum – Threads Archive

There are no more pages available in filegroup

I have created a script which will reindex all the user tables in all dbs of srvr.But unfortunately for one db i got the error.How to accomplish the reindexing task for this db.The error I am getting is as follows.
Reindexing All Tables in control
Server: Msg 1101, Level 17, State 2, Line 1
Could not allocate new page for database ‘control’. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth.
[ctrl].[TE01_WORK_DETAILS]
The statement has been terminated. I have checked the fragmentation of this db , and it have a scan density of 55%.
what to do now?

Check the free space available on the database by running SP_SPACEUSED @UPDATEUSAGE=’TRUE’ and also check whether aUTOGROW is enabled on this database for PRIMARY filegroup. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Here is the result of this db by running SP_SPACEUSED UPDATEUSAGE=’TRUE’
dbname dbsize unallocatedspace
control 2.94 MB0.09 MB resrerved data indexsize unused
1896 KB 1352 KB472 KB 72 KB Auto grow is enabled.So what is the proplem here

Expand the primary filegroup on this database to accomodate the rebuild process. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

IS there any sp or TSQL command available to achive this, because I again got a similar error today.This time I was not reindexing, rather creating table.I belive if the solution to fix this error will be automated it will be helpful in near future.Pls suggest

Here is the error which i got
Server: Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object ‘(SYSTEM table id: 3)’ in database ‘admin’ because the ‘PRIMARY’ filegroup is full.

Then follow as suggested in the books online for the ERror 1105 topic.
Action
To gain more space, you can free disk space on any disk drive containing a file in the full filegroup, allowing files in the group to grow. Or you can gain space using a data file with the specified database. Freeing disk space
You can free disk space on your local drive or on another disk drive. To free disk space on another drive: Move the data files in the filegroup with an insufficient amount of free disk space to a different disk drive.
Detach the database by executing sp_detach_db.
Attach the database by executing sp_attach_db, pointing to the moved files.
Using a data file
Another solution is to add a data file to the specified database using the ADD FILE clause of the ALTER DATABASE statement. Or you can enlarge the data file by using the MODIFY FILE clause of the ALTER DATABASE statement, specifying the SIZE and MAXSIZE syntax. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>