Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-07 Thread Stefan Heymann li...@stefanheymann.de [firebird-support] 
> Besides that, is there any other advantage of gbak or nbackup
> against an ordinary copy of the database?

When a GBAK backup finishes successfully you know that your database
is physically intact. When a restore finishes successfully you also
know that your database is logically intact (consistent).

As you mentioned, running a GBAK or NBACKUP backup doesn't require you
to shutdown the database. You may find some time to do that now but
maybe in a few years your users won't be happy anymore that there is a
service outage once a day.

A GBAK backup does a garbage collection on the database (unless you
use the -g switch).


Best Regards

Stefan

Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 3-5-2018 17:05, Javier Cintron fcintr...@yahoo.com [firebird-support] 
wrote:
> 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.

Yes, and if you use alter database begin/end backup you don't need to 
shutdown Firebird either.

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

A gbak backup is likely smaller, and may do some additional housekeeping 
while it is running.

Nbackup can be incremental, meaning less needs to be backed up per 
backup (this can make it more complex to do correctly though).

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

As Dimitry already answered that: no. OS shutdown or reboot will result 
in a controlled termination of services and signalling to other 
applications they need to be stopped (assuming it is a controlled 
restart and not physically resetting or shutting off power).

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-03 Thread Javier Cintron fcintr...@yahoo.com [firebird-support] 
 Thank you
On Thursday, May 3, 2018, 10:07:21 AM CDT, Stefan Heymann 
li...@stefanheymann.de [firebird-support]  
wrote:  
 
     
> When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance first?

Yes. Becaus when you don't do that, the server may access the file
during your copy process and you would get a corrupt file copy.

> and If yes, what is the proper way to shutdown and startup it?

You can use the GFIX tool with the option

-shut full

to shutdown the database so Firebird will not access the file and

-online normal

to put it back online.

Examples:

gfix -user SYSDBA -password masterkey dbserver:mydb -shut full -force 0

gfix -user SYSDBA -password masterkey dbserver:mydb -online normal

> When I need to restart Windows Server, Do I need to shutdown the
> Firebird instance first?

No.

Best Regards

Stefan


  #yiv3821471310 #yiv3821471310 -- #yiv3821471310ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3821471310 
#yiv3821471310ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3821471310 
#yiv3821471310ygrp-mkp #yiv3821471310hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3821471310 #yiv3821471310ygrp-mkp #yiv3821471310ads 
{margin-bottom:10px;}#yiv3821471310 #yiv3821471310ygrp-mkp .yiv3821471310ad 
{padding:0 0;}#yiv3821471310 #yiv3821471310ygrp-mkp .yiv3821471310ad p 
{margin:0;}#yiv3821471310 #yiv3821471310ygrp-mkp .yiv3821471310ad a 
{color:#ff;text-decoration:none;}#yiv3821471310 #yiv3821471310ygrp-sponsor 
#yiv3821471310ygrp-lc {font-family:Arial;}#yiv3821471310 
#yiv3821471310ygrp-sponsor #yiv3821471310ygrp-lc #yiv3821471310hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3821471310 
#yiv3821471310ygrp-sponsor #yiv3821471310ygrp-lc .yiv3821471310ad 
{margin-bottom:10px;padding:0 0;}#yiv3821471310 #yiv3821471310actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3821471310 
#yiv3821471310activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3821471310
 #yiv3821471310activity span {font-weight:700;}#yiv3821471310 
#yiv3821471310activity span:first-child 
{text-transform:uppercase;}#yiv3821471310 #yiv3821471310activity span a 
{color:#5085b6;text-decoration:none;}#yiv3821471310 #yiv3821471310activity span 
span {color:#ff7900;}#yiv3821471310 #yiv3821471310activity span 
.yiv3821471310underline {text-decoration:underline;}#yiv3821471310 
.yiv3821471310attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3821471310 .yiv3821471310attach div a 
{text-decoration:none;}#yiv3821471310 .yiv3821471310attach img 
{border:none;padding-right:5px;}#yiv3821471310 .yiv3821471310attach label 
{display:block;margin-bottom:5px;}#yiv3821471310 .yiv3821471310attach label a 
{text-decoration:none;}#yiv3821471310 blockquote {margin:0 0 0 
4px;}#yiv3821471310 .yiv3821471310bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3821471310 
.yiv3821471310bold a {text-decoration:none;}#yiv3821471310 dd.yiv3821471310last 
p a {font-family:Verdana;font-weight:700;}#yiv3821471310 dd.yiv3821471310last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3821471310 
dd.yiv3821471310last p span.yiv3821471310yshortcuts 
{margin-right:0;}#yiv3821471310 div.yiv3821471310attach-table div div a 
{text-decoration:none;}#yiv3821471310 div.yiv3821471310attach-table 
{width:400px;}#yiv3821471310 div.yiv3821471310file-title a, #yiv3821471310 
div.yiv3821471310file-title a:active, #yiv3821471310 
div.yiv3821471310file-title a:hover, #yiv3821471310 div.yiv3821471310file-title 
a:visited {text-decoration:none;}#yiv3821471310 div.yiv3821471310photo-title a, 
#yiv3821471310 div.yiv3821471310photo-title a:active, #yiv3821471310 
div.yiv3821471310photo-title a:hover, #yiv3821471310 
div.yiv3821471310photo-title a:visited {text-decoration:none;}#yiv3821471310 
div#yiv3821471310ygrp-mlmsg #yiv3821471310ygrp-msg p a 
span.yiv3821471310yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3821471310 
.yiv3821471310green {color:#628c2a;}#yiv3821471310 .yiv3821471310MsoNormal 
{margin:0 0 0 0;}#yiv3821471310 o {font-size:0;}#yiv3821471310 
#yiv3821471310photos div {float:left;width:72px;}#yiv3821471310 
#yiv3821471310photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv3821471310 
#yiv3821471310photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3821471310
 #yiv3821471310reco-category {font-size:77%;}#yiv3821471310 
#yiv3821471310reco-desc {font-size:77%;}#yiv3821471310 .yiv3821471310replbq 
{margin:4px;}#yiv3821471310 #yiv3821471310ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3821471310 #yiv3821471310ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3821471310

Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-03 Thread Javier Cintron fcintr...@yahoo.com [firebird-support] 
 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 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 3-5-2018 16:11, Javier Cintron fcintr...@yahoo.com [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:#ff;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

Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-03 Thread Stefan Heymann li...@stefanheymann.de [firebird-support] 
> When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance first?

Yes. Becaus when you don't do that, the server may access the file
during your copy process and you would get a corrupt file copy.

> and If yes, what is the proper way to shutdown and startup it?

You can use the GFIX tool with the option

-shut full

to shutdown the database so Firebird will not access the file and

-online normal

to put it back online.

Examples:

gfix -user SYSDBA -password masterkey dbserver:mydb -shut full -force 0

gfix -user SYSDBA -password masterkey dbserver:mydb -online normal


> When I need to restart Windows Server, Do I need to shutdown the
> Firebird instance first?

No.


Best Regards

Stefan

Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
03.05.2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
>  1. When I need to copy my Firebird database: Do I need to shutdown the 
> Firebird instance
> first? and If y es, what is the proper way to shutdown and startup it?

   You may shut it down or use nbackup or use ALTER DATABASE BEGIN BACKUP 
query. nbackup 
is the simplest way.

>  2. When I need to restart Windows Server, Do I need to shutdown the Firebird 
> instance first? 

   No. Windows correctly shut every service down before restart.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Proper way to handle an open Firebird database...

2018-05-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 3-5-2018 16:11, Javier Cintron fcintr...@yahoo.com [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