Hello,
I had a 500 MB Size Firebird Database File with .FDB extension. i deleted all the data from the database file. even then it is showing the size of 500 MB. how to reduce the size of the Firebird Database File size as there are no records in it. is there any command to do that?
Best Regards.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Supplementing NickUpson's advice I add, that by default during database restoration some free space is still reserved in the database's file in order to accelerate the manipulation of data in the future (inserts, updates etc.). If you are going to use your database in the read-only mode (e.g. on CD) then during database restoration you can use option "use_all_space".
Business Accounts
Answer for Membership
by: MicheleMarconPosted on 2008-06-30 at 06:45:18ID: 21899050
Firebird will re-use the space that has become available in the file.
The reason that your file doesn't "shrink", is that files simply cannot shrink, they can only become larger. Whenever some application creates a smaller file, it will re-create the file and remove the old file.
Obviously, for a database, this doesn't make sense. You don't want to delete the database file and re-create a new one, just to free up some disk space. Imagine Firebird doing this every now and then on huge files like 40 or 100 Gb. Instead, it will re-use empty space inside the file.
If you really want to do this, create a new database with the same structure... but I don't think this is what you want.