Subject | Re: [firebird-support] Proper way to handle an open Firebird database... |
---|---|
Author | Mark Rotteveel |
Post date | 2018-05-03T14:22:20Z |
On 3-5-2018 16:11, Javier Cintron fcintrono@... [firebird-support]
wrote:
In most cases the proper action will be to backup the database through
gbak or maybe nbackup instead of copying the database file. However, if
for some reason you really need/want to backup by manually copying the
file, then you should change the database to backup mode, copy the file
and disable backup mode.
This can be done with
ALTER DATABASE BEGIN BACKUP;
+ (commit)
Copy file
ALTER DATABASE END BACKUP;
+ (commit)
Mark
--
Mark Rotteveel
wrote:
> Firebird ver 2.5.7.27050 64 bitsExactly why do you want to copy your Firebird database?
> Superserver
> Windows Server 2012R2
>
> I have two questions:
>
> 1. When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance first? and If yes, w< span style="color: rgb(0, 0,
> 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
> font-size: 16px;">hat is the proper way to shutdown and startup it?
> 2. When I need to restart Windows Server, Do I need to shutdown the
> Firebird instance first?
In most cases the proper action will be to backup the database through
gbak or maybe nbackup instead of copying the database file. However, if
for some reason you really need/want to backup by manually copying the
file, then you should change the database to backup mode, copy the file
and disable backup mode.
This can be done with
ALTER DATABASE BEGIN BACKUP;
+ (commit)
Copy file
ALTER DATABASE END BACKUP;
+ (commit)
Mark
--
Mark Rotteveel