On 3-5-2018 16:11, Javier Cintron [email protected] [firebird-support] 
wrote:
> Firebird ver 2.5.7.27050 64 bits
> 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? 

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;
+ (commit)

Copy file

ALTER DATABASE END BACKUP;
+ (commit)

Mark
-- 
Mark Rotteveel

Reply via email to