Dear Helen,

Thank you for your response.

The whole purpose of my sweep/backup/restore on a 3-4 week basis is for garbage (transaction) control. These are the exact command I do on a routine basis

gfix -user SYSDBA -password "masterkey" DBNAME.FDB -sweep

gbak -v -t -user SYSDBA -password "masterkey" DBNAME.FDB DBNAME.FBK

gbak -c -v -p 8192 -user SYSDBA -password "masterkey" DBNAME.FBK DBNAME2.FDB

yes, I do put the double quotes around the password and there is no -b switch in the backup command.

Could you advise if the above commands are the proper commands I should be executing? In some other threads I do recall reading that a sweep is not necessary if a backup/restore is performed, but I do it anyway. Very often there is discussion in this forum regarding the proper commands to use,but I use the above and they seem to solve my problems.

Please advise.

Also, I realise that I should perform better transaction control so that the garbage doesn't build up in the first place.

Thank you Helen.

Theodore

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 04, 2010 12:10 PM
Subject: RE: [firebird-support] gbak appears to be frozen



At 12:14 PM 4/08/2010, Theodore Zafiropoulos wrote:
>Hello,
>
>Just giving an update on the gbak process.
>
>The gbak finally completed. After deleting the 70 Million records and entering the following gbak command
>
>gbak -v -t -user SYSDBA -password "masterkey" DBNAME.FDB DBNAME.FBK
>
>this process took approx. 88 Hours to complete

Now I am curious as to whether you actually included the -b[ackup] switch in the original command....and also about those double quotes around the -password argument.

./heLen





[Non-text portions of this message have been removed]