Automatic Backup Procedure for the Database

Post Reply

jhambach
Posts: 2
Joined: Thu May 08, 2008 10:21 am

Automatic Backup Procedure for the Database

Post by jhambach » Thu May 08, 2008 10:31 am

Dear all,

is there any procedure instead of the backup procedure in the Servermanager? I would like to make a (daily) sheduled backup at night. Is it possible to make any scripting? Any experiences?

Best regards,
Jens


Ckral
Posts: 21
Joined: Mon Jul 04, 2005 2:19 pm
Location: Munich
Contact:

Re: Automatic Backup Procedure for the Database

Post by Ckral » Sat May 17, 2008 11:51 am

yes of course.

You can use the Firebird Backup utility "gbak" to backup and restore the database on the command line.

Assuming you installed EPOline in c:\epoline3\ the command line would be

c:\epoline3\Firebird-1.5.3.4870\bin\gbak -v -t -y c:\backup.log -user SYSDBA -password masterkey c:\epoline3\eOLFI.gdb c:\backup.fbk

Also remember to backup c:\epoline3\eolfdi.gdb .

If you take a binary peek at the files in c:\epoline3\e3tools\e3SManager\ you can see that the .bk-files the E3manager creates are the same.
Christoph Kral

IT-Department VJP Munich
Email: ckral@vjp.de


Post Reply