Disk size did not change after clearing the tables

benjie

Member
Hi,

We are trying to have more disk space in our database server by clearing some tables using generate table in OMW, however the size of the database did not change in folder MSSQL/ Business Data although the cleared tables has 0 records, is there any batch program (UBE) to reclaim disk space after clearing the table?

Thanks in advance.

Benjie
E9.0/TR8.98.4/WAS7.0/MSSQL2008
 
Benjie,

real databases don't work that way. Database tables share space in one or more large files. Releasing space inside of a file has no impact on disk space allocation.

and by-the-way, should you google and find out how to shrink database files ... don't. Its a sure way to kill database performance.

However all is not lost - you may have lots of wasted space on your database server that's reclaimable - but you'll need someone who knows what they're doing to check your configuration and perform cleanup.

Cheers
 
Hi,

We are trying to have more disk space in our database server by clearing some tables using generate table in OMW, however the size of the database did not change in folder MSSQL/ Business Data although the cleared tables has 0 records, is there any batch program (UBE) to reclaim disk space after clearing the table?

Thanks in advance.

Benjie
E9.0/TR8.98.4/WAS7.0/MSSQL2008

You're not likely to regain much space from clearing a single table. How many records were in the table?
 
You can always check the size of the table and will know if it worth to shrink DB file using SQL management or you can use TSQL

Right click DB, Task, Shrink. Screen will tell you how much space you can gain. (always use File shrink not DB).

Select option
reorganize page option before releasing the unused space
Note. This option will grow transaction log if you have full recovery setup. You can set you DB to simple and shrink log file if it is go crazy or do it before. After hours is ideal


Thanks
 
Back
Top