[firebird-support] Re: Modify database structure, add and drop indexes while in heavy use?

2015-12-15 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
Please note that I attempted to backup and restore the database in hopes that the problem would be resolved. This is what I tried: gbak -b E:/mydata.fdb e:/mydata.fbk -user sysdba -password masterkey -v It started off well and "wrote data for table" for 3 of the 4 tables. When it started to

[firebird-support] Re: Modify database structure, add and drop indexes while in heavy use?

2015-12-15 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
Problem finally resolved by GBAK using the -g option to disable garbage collection. After creating my backup, I restored using GBAK and my problem was completely resolved. My question remains though. Is it a bad idea to modify a database as indicated above during heavy use? Thank you. On Tue,