need help with database error

[Former Member]

hi i get this error when trying to create a program -

---

> Could not allocate space for object 'SNAP' in database 'D01' because the 'PRIMARY' filegroup is full.

can someone tell me how to fix this problem.

thanks in advance

[Former Member · Accepted solution]

Hi Michael,

the database seem to be full. kindly log on to the server and check if there is space available on the drive where the datafiles are located on the server.

thanks

Abhijeet

[Former Member · Accepted solution]

Hi

i logged in to the server there is still 40 gb available space on it.

could it be with hte allocated size of the ndf file??

thanks

[Former Member · Accepted solution]

Yes,

Wat version of SQL are you using?

For SQL 2000 logon to Enterprise Manager, from the console window navigate to the database and check the name of the database that you have provided. right click and go to properties and check the "datafiles" tab. At the bottom of the screen you will find file properties, check wat are the properties.

also you can delete the data from SNAP table by running some standard progam "RSSNAPDL". Refer SAP Notes 11838, 40918 and 126974 and then implement the program in your system so that the SNAP table doesnt get full.

Thank you

Abhijeet

[Former Member · Accepted solution]

Ok i'll try that

thanks alot. by the way is it ok for me to just change the allocated space for the datafiles??

[Former Member · Accepted solution]

by the way im using sql 2000

[Former Member · Accepted solution]

Hi Michael,

Try to extend Filegrow for database tempdb and <SID> database in Enterprise Manager.

Regards,

Marcin Gajewski

[Former Member · Accepted solution]

Yes, you can do that!