Subject | RE: [firebird-support] Safe Automation of BackUp/Restore |
---|---|
Author | Alan McDonald |
Post date | 2005-09-15T01:17:09Z |
> Apparently firebirdfrequent backups are good - restores are not required frequently, once or
> requires regular Backup and Restores.
twice a year is still regular.
> Our customers are mainly computer illiterateyou should NEVER overwrite a db with a restore. Always restore to secondary
> so we would like to be able to backup and restore
> in such a way,
> as if the cycle fails the backup and restore does not
> make the situation worse by overwriting a half decent GDB
> with a failed backup file.
file.
My maintenance amounts to frequent backups and test restores to alternative
named dbs but the once yearly restore to the production environment is
manual in this order:
1. shut down server
2. rename production db to another name
3. start server again (noone can connect)
4. backup it up
5. restore it to the non-production name (noone can connect while you are
restoring)
6. if all successful - stop server again
7. rename to production
8. start server.
You're back in action
grab a copy of this
http://www.is.svitonline.com/ddking/
Alan
>
> Does anyone know of any component that does this?
>
> Regards,
>
> Robert.
>