Tablespace is possibly full ( with load tables)

[Former Member]

Hi Gurus,

I am running SGEN Commond on ECC5.0 IDES System.

installed on windows 2003 server & SQL2005 Server.

it was giving me an Error: 380 generation error(s): Tablespace is possibly full ( with load tables)

How to increase table space in SQL server.

Darshan...

[Former Member]

Table Space in SQL server

[Former Member]

What does that mean?

There is no concept of table space in SQL Server (like you have in Oracle or other RDBMS).

Its either the data files that store all your tables and indexes or the transaction log. If you are getting a table space error either the data files are not expanding or your transaction log might be full.

If the problem is the data files you can follow the steps above.

If you think it might be the transaction log, you can follow the same steps and allow it to autogrow or you can schedule more frequent backups. You can also check the transaction log for fullness at any time by using "DBCC SQLPERF(Logspace)" inside management studio.

Does that clarify your issue?

[Former Member]

Hi,

Increase the Tablespace using by SQL Server 2005 management studio or SQL query analyzer.

Regards,

Srini Nookala

[Former Member]

Check your datafile settings. Are they set to autogrow? If so by how much, if its a small number it might not be able to keep up with the SGEN, try expanding the files before you start.

Check your file system to make sure the datafile(s) have room to grow.

To check the datafile settings, In management studio right click on your DB name then go to Properties and then Files. From there it should be fairly self explanatory. You can also see what drives the files are located on there so you can check to see how much free space they have on the file system.