• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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
 

Larry_Jones

Legendary Poster
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
 

brother_of_karamazov

Legendary Poster
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?
 

adeel

VIP Member
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
 
Top