|Subject||Re: [firebird-support] Proper way to handle an open Firebird database...|
On Thursday, May 3, 2018, 9:22:38 AM CDT, Mark Rotteveel mark@... [firebird-support] <firstname.lastname@example.org> wrote:
On 3-5-2018 16:11, Javier Cintron fcintrono@... [firebird-support]
> Firebird ver 22.214.171.124050 64 bits
> 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?
Exactly why do you want to copy your Firebird database?
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;
ALTER DATABASE END BACKUP;