Subject | Re: [firebird-support] Gbak slow across network |
---|---|
Author | Slalom |
Post date | 2008-07-23T16:16:55Z |
Executing everything on ServerB results in a backup taking about 20 minutes. The NICs on both servers are set to auto negotiate. Are you saying to adjust to 100 half duplex?
----- Original Message ----
From: Alexandre Benson Smith <iblist@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, July 23, 2008 11:06:38 AM
Subject: Re: [firebird-support] Gbak slow across network
slalom91 wrote:
Don't know if it's your case, but once I found gbak running very slow
trougth a LAN, I had set the network card to run on 100mpbs half-duplex
(auto negotiating was seting to 100mpbs full-duplex) and the speedy was
increased *a lot* !
Give it a try.
By the way, how much time the back-up process take to run on the same
computer using a TCP connection ? Something like:
gbak localhost:c: \databaseA. fdb c:\temp\backupa. fdb -b -g -l -user SYSDBA -pas masterkey
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware. com.br
[Non-text portions of this message have been removed]
----- Original Message ----
From: Alexandre Benson Smith <iblist@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, July 23, 2008 11:06:38 AM
Subject: Re: [firebird-support] Gbak slow across network
slalom91 wrote:
> Good Morning,A shot in the dark...
>
> I am trying to troubleshoot an issue in which gbak is terribly slow
> while trying to back up a database from a remote server to a local
> drive. Server A is executing the following command
>
> "gbak ServerB:c:\database A.fdb c:\temp\backupa. fdb -b -g -l -user
> SYSDBA -pas masterkey"
>
> This command results in the database backup file landing on Server A's
> c:\temp folder. This is what I am after. However, it takes almost 8
> hours to complete. The database size is 11GB and the backup file is
> 8GB. I am assuming I am using this wrong or perhaps may be a better
> way to get this done. The goal is to end up with the backup file on
> Server A.
>
Don't know if it's your case, but once I found gbak running very slow
trougth a LAN, I had set the network card to run on 100mpbs half-duplex
(auto negotiating was seting to 100mpbs full-duplex) and the speedy was
increased *a lot* !
Give it a try.
By the way, how much time the back-up process take to run on the same
computer using a TCP connection ? Something like:
gbak localhost:c: \databaseA. fdb c:\temp\backupa. fdb -b -g -l -user SYSDBA -pas masterkey
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware. com.br
[Non-text portions of this message have been removed]