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 <nftimm...@hotmail.com <mailto:nftimm...@hotmail.com>> 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
    Firebird-net-provider@lists.sourceforge.net
    <mailto:Firebird-net-provider@lists.sourceforge.net>
    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
Firebird-net-provider@lists.sourceforge.net
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to