This is how I ended up doing it: Initially I have been using IBOServices to do my local hard drive FDB backups.
My routine that seems to work now: 1. Check for connected users using a query of MON$Attachments, other than connection used in the utility app. 2. Disconnect the app I'm using. 3. GFIX shut force 0 4. Do a IBOServices backup with verbose, mainly to make sure the backup file actually exists on the server when the code progresses to the restore line. This creates a file with a time string embedded in its name. 5. IBOServices RESTORE simply does not work to write over the existing FDB, so I use a ShellAPI call to GBAK using the service mgr -r o switch. Works fine. The backup gives me some confidence that I have a good file if something should go wrong when restoring directly to the DB. Afterward, I re-open the queries for the program, after putting the DB online and re-connecting. Is there something I'm missing for doing this DB backup/restore maintenance? Thank you, Chuck Belanger > Hello: > > After using Firebird (2.5 SS) exclusively in a desktop application > environment, I've created an associated app that stores data at an > internet address. > > I just finished the code to allow me via a remote site to backup and > immediately restore as a maintenance operation the database. > > My plan was to back up to a temp file, then restore that to another temp > file, Disconnect, Shutdown the database with GFIX then FTP.rename the > original database to a filename with time stamp string and then > FTP.rename the temp file to the original database name. > > My mistake is that GFIX shutdown would allow this to happen. > > How do you allow a rename of the database in an FTP operation? Or is > there a better way of doing what I am trying to do? I am hesitant to do > a restore directly over the original database, but maybe someone can > advise me on that? > > Thank you, > > Chuck Belanger > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > >
