Subject Re: [firebird-support] Unlocking a database with active connections
Author Tomasz Tyrakowski
First of all, thank you Sean for the reply.

On 2013-03-18 17:46, Leyne, Sean wrote:
>
>
>> Is it safe to unlock (nbackup -N) a database when there's a quite large delta
>> file present and there are clients connected?
>
> Yes.

I did the merging without connected clients after all, just in case ;)
Everything went fine.

> BTW, define "large".

40GB database, 5GB delta. Mering took just a few seconds on a double
quad-core Xeon server with a hardware raid-10 SAS matrix and 64GB of RAM.
OK, I admit. Writing "large" was a bit lame.

> The engine will work to merge the changes as quickly as possible and will serve pages/requests at the same time.

Thanks for the info. Like i said, not being sure what may happen, I
waited the clients out ;). I would be in a deep dudu if a production
database went askrew. And please, don't ask how I got myself a 5-gig
delta file ;)

regards
Tomasz

--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__