Subject Re: [firebird-support] Proper way to handle an open Firebird database...
Author Javier Cintron
Post date 2018-05-03T15:05:23Z
Yes That is right, I want to backup the database. 

I have a gap in the nigth to do it. 

I understand that by using gbak or nbackup Firebird doesnt need to be shutdown. 

Besides that, is there any other advantage of gbak or nbackup against an ordinary copy of the database?

By the way If a need to restart the server, Do I need to shutdown Firebird first?

Thanks in advance



On Thursday, May 3, 2018, 9:22:38 AM CDT, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


 

On 3-5-2018 16:11, Javier Cintron fcintrono@... [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