Disk space error

Question

Hello,

I am getting the following error whenever i try to run the stored procedure

Could not allocate space for object 'sys.sysrscols'.'clust' in database 'ABCDEFG' 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.

Thanks In Advance

Ajay Chauhan

Answer 1

http://www.banmanpro.com/support/filegroupfull.asp

Try this...

Answer 2

It is possible that during some DML operation the file has to be grown to specific size and there was no space on disk.... 

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

Do you have a space problem?

If yes, do as suggested above: cleanup, add additional file(s).

Also do:

DBCC checkdb

---

Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES

Answer 4

Hello,

Probably the database files don't have autogrowth settings well configured 

Try below script to get this info from all databases

http://sql-javier-villegas.blogspot.com/2011/10/informacion-util-acerca-de-las-bases-de.html

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you