Re: [firebird-support] Database Too Large.

2014-06-29 Thread marcus mar...@antiphasis.net [firebird-support]
IIRC that's the second user having problems with SAM Broadcast using firebird. The Product company Spacial Audio has its own support site at https://spacialaudio.zendesk.com/home, that should be your way to ask for help, as they do know how their application talks to the database. And, as

Re: [firebird-support] Database Too Large.

2014-06-27 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 27/06/14 08:43, 'stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support] wrote: i run SAM Brodcaster (Webradio Automation Software) with firebird database. I've a big problem because SAMDB.FDB increase day after day in an exaggerated way. After 150 days of running the db

Re: [firebird-support] Database Too Large.

2014-06-27 Thread 'stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support]
I use SAM Broadcaster Webradio Automation Program. I have an Event.log (Contain everything that happens in the radio) and a History (all the songs played) but if i check the Backup Size is 6/7 mb. The SAMBC.FDB it is growing every day, before reset was 3 Mb (with ALL of the webradio songs

Re: [firebird-support] Database Too Large.

2014-06-27 Thread Werner werner...@gmx.ch [firebird-support]
Hi Stefano, On 6/27/2014 11:01, 'stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support] wrote: I use SAM Broadcaster Webradio Automation Program. You need to give more information on the above, a link would already be good. Better would be what Firebird SQL access tool is

Re: [firebird-support] Database Too Large.

2014-06-27 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Stefano, To decrease database size you need to make backup/restore. Then, to keep its growth under control, you need to perform the following maintenance procedure: 1) stop Firebird server and then start it immediately (less than 3 sec downtime). 2) run gfix -sweep -user SYSDBA -pass