Subject | Examples/ideas on scripts for nightly backups/restores? |
---|---|
Author | rjschappe |
Post date | 2005-03-04T20:03:08Z |
I want to make sure that my backup scripts are correct, so I am
looking for some examples...
Right now I perform the following:
gbak -backup to a temp file in a /backup directory
if exit code ok
gbak -create to restore to a /temp directory
if exit code ok
stop firebird service
move good restore into /production directory
rename as original database name
start firebird service
gzip original temp backup file in /backup dir
My questions... is there a better way to do this?
Instead of shutting down the firebird service... should I use gfix -sh
instead like this:
gfix -sh -f 600 database
move good restore into /production directory
rename as original database name
gfix -online database
Many thanks,
--Raymond
looking for some examples...
Right now I perform the following:
gbak -backup to a temp file in a /backup directory
if exit code ok
gbak -create to restore to a /temp directory
if exit code ok
stop firebird service
move good restore into /production directory
rename as original database name
start firebird service
gzip original temp backup file in /backup dir
My questions... is there a better way to do this?
Instead of shutting down the firebird service... should I use gfix -sh
instead like this:
gfix -sh -f 600 database
move good restore into /production directory
rename as original database name
gfix -online database
Many thanks,
--Raymond