Reducing Database size

Articles and documents provided by support staff covering Mailtraq features and general operation.

Reducing Database size

Postby Susan Bunbury » Tue Jan 31st, 2006 9:26am

The Firebird Database size grows as messages are added and indexes written. If you delete messages, the database size does not go down, but space is created inside the structure, so that new messages (for a while at least) do not cause the Database to grow - until that created space is used up.

If one needed to reduce the Database size (without resorting to other 'external' tools) one may do the following:

1) Make a backup to "path"
2) Shut down Mailtraq
3) Rename the current "mailtraq.fdb" to something else
4) Run
mailtraq.exe -ibrestore "path"
(where "path\mailtraq.fbk" exists)


Note 1.

There are also "calrestore", "disrestore" and "cfgrestore" flags that work in a similar way.

Note 2.

You cannot restore to an active database.
Firebird sees that the integrity of the current database is good, and that the current database is newer, so it refuses the backup.

Also: Development are currently (Jan/Feb '06) working to simplify this procedure, and we will update this FAQ accordingly.
Best wishes,
Susan

Sales and Initial Support
Enstar Mailtraq
User avatar
Susan Bunbury
Mailtraq Enstar Sales and Support
 
Posts: 359
Joined: Mon Aug 22nd, 2005 3:09pm
Location: CT, USA

Return to Mailtraq Knowledgebase and FAQ

Who is online

Users browsing this forum: No registered users and 2 guests

cron