24.03.2016 11:27, Simonov Denis wrote:
> Vlad Khorsun <hv...@users.sourceforge.net> wrote Wed, 23 Mar 2016 17:43:23
> +0300:
>
>>
>> Let me show how it works. It is very simplified example, of course.
>>
>> Create database source.fdb.
>>
>> Create level-0 backup, as usual:
>> nbackup -B 0 source.fdb source-0.nbk
>>
>> Restore level-0 backup, as usual:
>> nbackup -R target.fdb source-0.nbk
>
> Why not combine these commands into one?
> backup -COPY source.fdb target.fdb
What if target host is not reachable for nbackup (and\or source) host ?
What if one need to have N target databases ?
If you worry about unnecessary file copying by nbackup -R, you may rename
source-0.nbk into target.fdb and use nbackup -F instead.
>> Every N minutes:
>> {
>> obtain backup GUID of target database:
>> gstat -h target.fdb | findstr /C:"Database backup GUID:"
>>
>> create new incremental backup using GUID above:
>> nbackup -B {93070E3C-E63F-4FB3-B89A-10C732BDEAC3} source.fdb
>> source-inc.nbk
>>
>> apply new increment to the target database:
>> nbackup -INPLACE -R target.fdb source-inc.nbk
>> }
>>
>
> These commands can also be combined into one, such as
> nbackup -MERGE -DATABASE source.fdb target.fdb [-INCREMENT
> source-inc.nbk]
>
> During the execution of this command, GUID could be read automatically
> from target.fdb
Same questions about multiply\not reachable target(s) as above.
For single target database in the same network it could make sense, agree.
Note, to query GUID of target database, it should be directly available for the
nbackup host or Firebird server should run on target host.
Regards,
Vlad
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
