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