| Subject | Database randomly growing is size??? |
|---|---|
| Author | timwilsonaus |
| Post date | 2011-02-04T05:18:46Z |
Have a database that for some reason overnight will double or triple in size from about 200MB up to about 600MB.
The DB is an FDB format and running on a server with the latest 2.5 Firebird version installed.
Running a Backup & Restore on the DB returns it back to it correct size. But I need a more permanent fix.
I have tried to monitor the DB size over the last few weeks and the DB size continues to spike. However I can see no pattern as to when this seems to occur or what might be causing it.
Has anyone had similar issue or any suggestions as to what might cause this?
The DB is an FDB format and running on a server with the latest 2.5 Firebird version installed.
Running a Backup & Restore on the DB returns it back to it correct size. But I need a more permanent fix.
I have tried to monitor the DB size over the last few weeks and the DB size continues to spike. However I can see no pattern as to when this seems to occur or what might be causing it.
Has anyone had similar issue or any suggestions as to what might cause this?