Re: [firebird-support] gbak asking for volume number 2 disk

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

Afternoon Sudheer,

 >   What causes gbak to ask for volume 2 number disk?
http://www.firebirdfaq.org/faq188/

It would appear that your backup file was found to be incomplete, 
unfortunately, and gbak is asking for the remainder of the backup.


 >I am using Firebird-2.5.4.26856_0_Win32 on Windows 7. The following
 > command line is used for taking the backup.
 >
 > gbak -t -v -b -user SYSDBA -password masterkey accounts.fdb 
J:\accounts.fbk
 >
 > 'J:\' is flash drive here.

Was your backup to the flash drive successful? Or did it run out of space?


HTH

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767

Re: [firebird-support] gbak asking for volume number 2 disk

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

PS. http://www.firebirdfaq.org/faq59/ might also apply.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767

Re: [firebird-support] Cannot Connect to FireBird Database from network workstation

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

Maybe a silly question, but is there a firewall that needs a port opening, 
between your host server  for the database,  and the clients? 


Cheers,
Norm.
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [firebird-support] How can I prevent that my database can be opened with another security.fdb.

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

I would suggest that the best way to prevent anyone getting hold of your 
database and opening it with a separate security database is to have good 
security & physical protection on your server, limited access to the server 
room (if appropriate) and so on. Normal security precautions in other words.

Keep all your backups safe and secure as well. These can be used against you 
also. You might want to consider encrypting them with something like GPG before 
sending them off-site - if that's what you would do in a production environment 
- or even storing them on-site where they might be accessible by "too many" 
people.

Just a few thoughts.


HTH

Cheers,
Norm.

On 7 April 2016 16:02:10 BST, "'Mueller, Roland (GE87)' 
roland.muel...@honeywell.com [firebird-support]" 
 wrote:
>Hi all
>How can I prevent that my database can be opened with another
>security.fdb.
>
>
>For testing we use firebird 3.
>
>
>We use our database as its own security database.
>If we copy our database to another Firebird installation it
>
>is possible to open it with sysdba and masterkey.
>Is there a way to prevent The use of another security.fdb.
>
>
>Roland Müller
>Dipl.Ing. (FH)
>Honeywell | Security and Fire
>Novar GmbH
>Johannes-Mauthe-Straße 14
>72458 Albstadt
>Büro: 07431 801-0
>Fax: 07431 801-1512
>
>
>roland.muel...@honeywell.com
>www.honeywell.com/security/de
>
>
>
>
>
>
>
>
>Novar GmbH
>Rechtsform: GmbH
>Sitz: Albstadt
>Registergericht: AG Stuttgart, HRB 401195
>Geschäftsführung: Martin Bemba, Klaus Hirzel, Marcus Lindenlaub, Marcus
>Ostländer
>Aufsichtsratsvorsitzender:  Martin Göth
>
>
>
>THIS E-MAIL AND ATTACHED FILES ARE CONFIDENTIAL, PROTECTED BY COPYRIGHT
>AND MAY BE LEGALLY PRIVILEGED. If you are not the intended addressee or
>have received this e-mail in error, any use of this e-mail or any
>copying, distribution or other dissemination of it is strictly
>prohibited. If you have received this transmission in error, please
>notify the sender immediately and then delete the e-mail. E-mail cannot
>be guaranteed to be secure, error free or free from viruses. Neither
>the sending company nor its group of companies accepts any liability
>whatsoever for any loss or damage that may be caused as a result of the
>transmission of this message by e-mail. If verification is required,
>please request a hard copy version.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [firebird-support] Time zones

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

If I may be permitted to stick my oar in here 

Oracle databases allow timestamp with timezone data types, as well as simple 
timezone data types. Every database I've come across in my day job, I'm an 
Oracle contract DBA, uses either date  (aka date and time) or simple timezone 
data types. 

Some of the internal stuff does use timezones,  and it's a right PITA working 
out what the actual time a job got scheduled at, for example.

Timezones, just say no! :-)

Other opinions are of course available. They are wrong! (Joke)


Cheers,
Norm.
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

Evening Arnaldo,

On 15/02/18 13:19, Arnaldo Caliari arnaldo.cali...@studiosoft.info 
[firebird-support] wrote:
> Hi guys,
> 
> maybe i have always misunderstood the garbage collection mechanism, the
> sweep interval, etc.. and i'm realising only now, but:

Welcome to my world! ;-)

> I have this database (Firebird 3.03 SuperServer x64)
>       Sweep interval:        0
> ...

> 
> My question is : why garbage collection mechanism starts automatically
> when i browse these tables, despite the fact that i have Sweep Interval
> = 0 ? What is the point that i'm missing ?

Sweep interval is for an automatic sweep which gets carried out when the 
Oldest snapshot transaction (OST) - Oldest Interesting Transaction (OIT) 
exceeds a non-zero setting for the sweep interval. In the header 
information, this is Oldest Snapshot minus Oldest Transaction.

Setting sweep interval to zero disables this automatic sweep. However, 
are you aware that when a transaction visits a table, it clears out 
'garbage' left behind by other previous transactions?

Also, when you backup the database, your garbage is/can be collected too.


HTH


Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767

Re: [firebird-support] Two aliases pointing to the same file

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

I've been doing that for years! I have, for example, an alias 'employee' and 
another 'employee.fdb' - if I remember correctly, it was originally used as an 
example when the aliases file was installed - many years ago. I just followed 
suit.


Cheers,
Norm.
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [firebird-support] Using a Raspberry Pi with Firebird?

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

I haven't set up Firebird on a raspberry pi yet, but I will one day.

I would use a powered usb drive or SSD rather than the SD card just because I'd 
want the data protected as much as possible.

It's not as bad as it used to be, admittedly, but SD cards still "wear" and 
definitely corrupt eventually - as my phone, tablet and AK100 music player have 
shown.(Quality cards too.)

HTH.

Cheers,
Norm.
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [firebird-support] Remote backup using gbak

[Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]]

Evening Kevin,

Sadly, not-text parts of your message were removed, so we can't see "what you 
got". Sorry.

Cheers,
Norm.

On 1 January 2020 19:23:06 GMT+00:00, "Kevin Stanton 
kevin.stan...@rdb-solutions.com [firebird-support]" 
 wrote:
>Greetings!
>
>I’m hoping someone can help me out here.  FB 1.56 (upgrading soon),
>trying to perform a remote backup.
>
>Here’s my batch file:
>
>cd "c:\program files\firebird15\bin"
>pause
>gbak -b -user sysdba -password masterkey -service
>win2012server:service_mgr "win2012server:c:\fb
>databases\lumber\lumber.fdb" "\common\lumber_remote.fbk"
>pause
>
>
>This is what I get:
>
>
>
>
>Thanks in advance!
>Kevin
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Posted by: Kevin Stanton 
>
>
>++
>
>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
>
>
>
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.