FM server 11-Removing Records and resizing db

[Nestor]

Good Morning all,

I have a database that's 18 gb and i removed about 3000 records out of 6000, but my database size only change from 18gb to 16gb. it should off removed about 8gb!!!.

how can i have the server resize the database? does it do it automatically?

i have FM server 11 advance.

thanks

Nestor

[dansmith65]

Closing the database, then opening it again will cause it to release unused space.

If you have already done that, then another option is to save a compact copy. Perhaps others can chime in on this, but I think there is the possibility for data corruption when you do this, so you should make sure your new file is ok before you use it. I don't know the details about this, nor do I know if this is accurate.

[Steven H. Blackwell]

how can i have the server resize the database? does it do it automatically?

FileMaker Server does not perform this function. Close the files, stop the server, and open the file in a copy of FIleMaker Pro. You can then save a compressed copy from the File Menu-->Save A Copy As...

Having deleted half the records before doing this probably was not the best approach. So it may take a while for the Save A Copy As process to run.

Steven

[Nestor]

Thanks for the info.