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
[email protected] [firebird-support] <[email protected]>
wrote:
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
#yiv8828140725 #yiv8828140725 -- #yiv8828140725ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8828140725
#yiv8828140725ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8828140725
#yiv8828140725ygrp-mkp #yiv8828140725hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8828140725 #yiv8828140725ygrp-mkp #yiv8828140725ads
{margin-bottom:10px;}#yiv8828140725 #yiv8828140725ygrp-mkp .yiv8828140725ad
{padding:0 0;}#yiv8828140725 #yiv8828140725ygrp-mkp .yiv8828140725ad p
{margin:0;}#yiv8828140725 #yiv8828140725ygrp-mkp .yiv8828140725ad a
{color:#0000ff;text-decoration:none;}#yiv8828140725 #yiv8828140725ygrp-sponsor
#yiv8828140725ygrp-lc {font-family:Arial;}#yiv8828140725
#yiv8828140725ygrp-sponsor #yiv8828140725ygrp-lc #yiv8828140725hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8828140725
#yiv8828140725ygrp-sponsor #yiv8828140725ygrp-lc .yiv8828140725ad
{margin-bottom:10px;padding:0 0;}#yiv8828140725 #yiv8828140725actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8828140725
#yiv8828140725activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8828140725
#yiv8828140725activity span {font-weight:700;}#yiv8828140725
#yiv8828140725activity span:first-child
{text-transform:uppercase;}#yiv8828140725 #yiv8828140725activity span a
{color:#5085b6;text-decoration:none;}#yiv8828140725 #yiv8828140725activity span
span {color:#ff7900;}#yiv8828140725 #yiv8828140725activity span
.yiv8828140725underline {text-decoration:underline;}#yiv8828140725
.yiv8828140725attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8828140725 .yiv8828140725attach div a
{text-decoration:none;}#yiv8828140725 .yiv8828140725attach img
{border:none;padding-right:5px;}#yiv8828140725 .yiv8828140725attach label
{display:block;margin-bottom:5px;}#yiv8828140725 .yiv8828140725attach label a
{text-decoration:none;}#yiv8828140725 blockquote {margin:0 0 0
4px;}#yiv8828140725 .yiv8828140725bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8828140725
.yiv8828140725bold a {text-decoration:none;}#yiv8828140725 dd.yiv8828140725last
p a {font-family:Verdana;font-weight:700;}#yiv8828140725 dd.yiv8828140725last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8828140725
dd.yiv8828140725last p span.yiv8828140725yshortcuts
{margin-right:0;}#yiv8828140725 div.yiv8828140725attach-table div div a
{text-decoration:none;}#yiv8828140725 div.yiv8828140725attach-table
{width:400px;}#yiv8828140725 div.yiv8828140725file-title a, #yiv8828140725
div.yiv8828140725file-title a:active, #yiv8828140725
div.yiv8828140725file-title a:hover, #yiv8828140725 div.yiv8828140725file-title
a:visited {text-decoration:none;}#yiv8828140725 div.yiv8828140725photo-title a,
#yiv8828140725 div.yiv8828140725photo-title a:active, #yiv8828140725
div.yiv8828140725photo-title a:hover, #yiv8828140725
div.yiv8828140725photo-title a:visited {text-decoration:none;}#yiv8828140725
div#yiv8828140725ygrp-mlmsg #yiv8828140725ygrp-msg p a
span.yiv8828140725yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8828140725
.yiv8828140725green {color:#628c2a;}#yiv8828140725 .yiv8828140725MsoNormal
{margin:0 0 0 0;}#yiv8828140725 o {font-size:0;}#yiv8828140725
#yiv8828140725photos div {float:left;width:72px;}#yiv8828140725
#yiv8828140725photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8828140725
#yiv8828140725photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8828140725
#yiv8828140725reco-category {font-size:77%;}#yiv8828140725
#yiv8828140725reco-desc {font-size:77%;}#yiv8828140725 .yiv8828140725replbq
{margin:4px;}#yiv8828140725 #yiv8828140725ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8828140725 #yiv8828140725ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8828140725
#yiv8828140725ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8828140725
#yiv8828140725ygrp-mlmsg select, #yiv8828140725 input, #yiv8828140725 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8828140725
#yiv8828140725ygrp-mlmsg pre, #yiv8828140725 code {font:115%
monospace;}#yiv8828140725 #yiv8828140725ygrp-mlmsg *
{line-height:1.22em;}#yiv8828140725 #yiv8828140725ygrp-mlmsg #yiv8828140725logo
{padding-bottom:10px;}#yiv8828140725 #yiv8828140725ygrp-msg p a
{font-family:Verdana;}#yiv8828140725 #yiv8828140725ygrp-msg
p#yiv8828140725attach-count span {color:#1E66AE;font-weight:700;}#yiv8828140725
#yiv8828140725ygrp-reco #yiv8828140725reco-head
{color:#ff7900;font-weight:700;}#yiv8828140725 #yiv8828140725ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8828140725 #yiv8828140725ygrp-sponsor
#yiv8828140725ov li a {font-size:130%;text-decoration:none;}#yiv8828140725
#yiv8828140725ygrp-sponsor #yiv8828140725ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8828140725
#yiv8828140725ygrp-sponsor #yiv8828140725ov ul {margin:0;padding:0 0 0
8px;}#yiv8828140725 #yiv8828140725ygrp-text
{font-family:Georgia;}#yiv8828140725 #yiv8828140725ygrp-text p {margin:0 0 1em
0;}#yiv8828140725 #yiv8828140725ygrp-text tt {font-size:120%;}#yiv8828140725
#yiv8828140725ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8828140725
