Subject | RE: [firebird-support] Re: Restoring a database |
---|---|
Author | Alan McDonald |
Post date | 2006-03-19T22:48:17Z |
> See above. Another side point, when you begin to restore the databaseyou'll need to restart the server for a new alias to take effect
> with the replace switch the first thing it does is to delete the old
> one. If the restore fails due to a corrupt backup file, you will be
> left with no database and an unrestorable backup of it. You may want
> to change the process slightly, rename the fdb file (this will prevent
> all connections but will only succeed if no-one is connected) then
> restore to a DIFFERENT filename (to prevent people from connecting
> during the restore), then rename that file to the correct name.
> Alternatively if you use aliases, you can point the alias elsewhere
> while you do all this.
>
>
> Adam
>
Alan