firebird-net-provider

Re: [Firebird-net-provider] fbbackup

[Nicolas T. <nft...@ho...>]

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

Re: [Firebird-net-provider] fbbackup

[Nicolas T. <nft...@ho...>]

Tank you
So doing the shutdown not necessary i need to call the clear pool right ? Because tje shitdown forced will close all connection be her from .net or othee?

Enviado pelo meu Windows Phone
________________________________
De: Mark Rotteveel
Enviada em: 22/03/2013 11:08
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] fbbackup

On Fri, 22 Mar 2013 13:48:21 +0000, Scott Price <sco...@vi...>
wrote:
> You shouldn't need to perform a server shut-down to perform a restore,
> and do not need to ever to perform a backup, though it's up to you if
> you choose to.  What you would need to do is make sure all connections
> to the database are closed.  If you are using the .NET ADO.NET provider
> only, you will by default probably be using connection pooling.  As
> such, you will likely need to have a call to
>
> FbConnection.ClearAllPools();
>
> That should drop all connections from the local perspective.  It will
> not help with any other machines connected to the database however.
>
> After a short pause to let any kind of clean up that's required to
> occur, you should be able to restore a database backup to that instance.

Shutting down a database means that the Firebird server will not accept
any connections for a specific database (or only accepts a single admin
connection). Depending on the exact config you can even force the server to
close existing connections. This is a much cleaner way than assuming that
the manual work to close connections is sufficient, or that your
applications is the only one to connect.

You can use FbConfiguration (in FirebirdSql.Data.Services) to shutdown a
database.

Mark

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbbackup

[Scott P. <sco...@vi...>]

You shouldn't need to perform a server shut-down to perform a restore, 
and do not need to ever to perform a backup, though it's up to you if 
you choose to.  What you would need to do is make sure all connections 
to the database are closed.  If you are using the .NET ADO.NET provider 
only, you will by default probably be using connection pooling.  As 
such, you will likely need to have a call to

FbConnection.ClearAllPools();

That should drop all connections from the local perspective.  It will 
not help with any other machines connected to the database however.

After a short pause to let any kind of clean up that's required to 
occur, you should be able to restore a database backup to that instance.


Kind regards,


Scott Price

On 22/03/2013 13:38, Nicolas Timmers wrote:
> You are right tank youu
>
> Someone know hpw to performe a database shutdown and online ???
>
> Enviado pelo meu Windows Phone
> ------------------------------------------------------------------------
> De: Gerdus van Zyl
> Enviada em: 22/03/2013 09:19
> Para: For users and developers of the Firebird .NET providers
> Assunto: Re: [Firebird-net-provider] fbbackup
>
> It will give an exception if there is a problem.
> you have to set Verbose = True on FbRestore/FbBackup so that the 
> program blocks until the backup is complete.
>
>         restore.Verbose = True
>         AddHandler restore.ServiceOutput, Sub(sender As Object, e As 
> ServiceOutputEventArgs)
>
>                                           End Sub
>
>
> On Fri, Mar 22, 2013 at 1:30 PM, Nicolas Timmers 
> <nft...@ho... <mailto:nft...@ho...>> wrote:
>
>     Hello everyone
>
>     I have a question,  when using the fbbackup on .net have a way to
>     know if the backup was completely sucesfull???
>
>     And wirh fbreatore??
>
>     Enviado pelo meu Windows Phone
>
>     ------------------------------------------------------------------------------
>     Everyone hates slow websites. So do we.
>     Make your web apps faster with AppDynamics
>     Download AppDynamics Lite for free today:
>     http://p.sf.net/sfu/appdyn_d2d_mar
>     _______________________________________________
>     Firebird-net-provider mailing list
>     Fir...@li...
>     <mailto:Fir...@li...>
>     https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
>
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbbackup

[Mark R. <ma...@la...>]

On Fri, 22 Mar 2013 13:48:21 +0000, Scott Price <sco...@vi...>
wrote:
> You shouldn't need to perform a server shut-down to perform a restore, 
> and do not need to ever to perform a backup, though it's up to you if 
> you choose to.  What you would need to do is make sure all connections 
> to the database are closed.  If you are using the .NET ADO.NET provider 
> only, you will by default probably be using connection pooling.  As 
> such, you will likely need to have a call to
> 
> FbConnection.ClearAllPools();
> 
> That should drop all connections from the local perspective.  It will 
> not help with any other machines connected to the database however.
> 
> After a short pause to let any kind of clean up that's required to 
> occur, you should be able to restore a database backup to that instance.

Shutting down a database means that the Firebird server will not accept
any connections for a specific database (or only accepts a single admin
connection). Depending on the exact config you can even force the server to
close existing connections. This is a much cleaner way than assuming that
the manual work to close connections is sufficient, or that your
applications is the only one to connect.

You can use FbConfiguration (in FirebirdSql.Data.Services) to shutdown a
database.

Mark