How to backup the remote database to a local hard disk

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

How to backup the remote database to a local hard disk

LtColRDSChauhan
Hi,

1.  Not able to back up:

\\ServerMachine\C\ABC.FDB
to
\\TheLocalMachine\C\ABC.GBK

2. The C drive of the TheLocalMachine is shared to Everyone with Allow Full Control.

Please help.

Regards,
Rajiv

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: How to backup the remote database to a local hard disk

Mark Rotteveel-2
On 23-3-2016 11:31, LtColRDSChauhan wrote:
> Hi,
>
> 1.  Not able to back up:
>
> \\ServerMachine\C\ABC.FDB
> to
> \\TheLocalMachine\C\ABC.GBK

Please show the code you use for the backup. You should be using
FbStreamingBackup if you want to backup to your local machine.

> 2. The C drive of the TheLocalMachine is shared to Everyone with Allow
> Full Control.

Note that Firebird does not allow you to connect to a database on a
network share (even if that share is local to the machine).

Mark
--
Mark Rotteveel

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: How to backup the remote database to a local hard disk

LtColRDSChauhan
In reply to this post by LtColRDSChauhan
Message: 4
Date: Wed, 23 Mar 2016 14:43:25 +0100
From: Mark Rotteveel <[hidden email]>
Subject: Re: [Firebird-net-provider] How to backup the remote database
        to a local hard disk
To: "For users and developers of the Firebird .NET providers"
        <[hidden email]>
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=utf-8; format=flowed

On 23-3-2016 11:31, LtColRDSChauhan wrote:
> Hi,
>
> 1.  Not able to back up:
>
> \\ServerMachine\C\ABC.FDB
> to
> \\TheLocalMachine\C\ABC.GBK

Please show the code you use for the backup. You should be using
 
Mark, thanks for your help.
I was using FBackup.

FbStreamingBackup if you want to backup to your local machine.
 
Using FbStreamingBackup solved my problem.
But the ServiceOutput event handler is now not getting called.

> 2. The C drive of the TheLocalMachine is shared to Everyone with Allow
> Full Control.

Note that Firebird does not allow you to connect to a database on a
network share (even if that share is local to the machine).

Mark
--
Mark Rotteveel



------------------------------

Message: 5
Date: Fri, 25 Mar 2016 07:11:57 +0100
From: "Nikolaus Kern" <[hidden email]>
Subject: [Firebird-net-provider] Entity Framework: Best practices to
        work in a multiuser environment
To: "'For users and developers of the Firebird .NET providers'"
        <[hidden email]>
Message-ID: <000001d1865d$3ccec780$b66c5680$@gmx.at>
Content-Type: text/plain; charset="us-ascii"

Hello all,



I am using EF 6.0 with Firebird 4.10 and have same questions about best
practices. It is an WPF/MVVM application that runs in a multiuser
environment.



1.       There is a static class to create the connection string

    AppGlobals
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals> .EFMetadata
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals/property:EFMetadata:String>  =
"res://*/LPP.csdl|res://*/LPP.ssdl|res://*/LPP.msl";
    AppGlobals
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals> .CreateConnectionString
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals/CreateConnectionString()> ();



2.       I am using long living efcontext as protected variable in the
ViewModel to read the data

        protected lehnerEntities
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities>  _ctx
<<a href="http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities" target="_blank" rel="noreferrer">http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> ;



3.       As long the user does not explicit reload the data I am working in
a connected mode



4.       Inserts, updates and deletes use the same context

        LPP_LOGISTIK_EISENBIEGEN
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.LPP_LOGISTIK_EISENBIEGEN>  entity = new
LPP_LOGISTIK_EISENBIEGEN
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.LPP_LOGISTIK_EISENBIEGEN/.ctor()> ();
        this._ctx
<<a href="http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities" target="_blank" rel="noreferrer">http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .LPP_LOGISTIK_EISENBIEGEN
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities/property:LPP_LOGISTIK_EISENBIEGEN:System.D
ata.Entity.DbSet%3cLppDataAccess.LPP_LOGISTIK_EISENBIEGEN%3e> .Add
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://EntityFramework:6
.0.0.0:b77a5c561934e089/System.Data.Entity.DbSet%3c%3e/Add(%3c!0%3e):%3c!0%3
e> (entity);
        this._ctx
<<a href="http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities" target="_blank" rel="noreferrer">http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .SaveChanges
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://EntityFramework:6
.0.0.0:b77a5c561934e089/System.Data.Entity.DbContext/SaveChanges():Int32>
();



5. When the user wants to refresh (F5) I instanciate the context again and
use it as before

    this._ctx
<<a href="http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities" target="_blank" rel="noreferrer">http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities>  = new lehnerEntities
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities/.ctor(String)> (AppGlobals
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals> .efSB
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals/property:efSB:System.Data.EntityClient.EntityConne
ctionStringBuilder> .ConnectionString
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://System.Data:4.0.0
.0:b77a5c561934e089/System.Data.Common.DbConnectionStringBuilder/property:Co
nnectionString:String> );
    this._auftraege
<<a href="http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v mEisenbiegerei/_auftraege:System.Linq.IQueryable%3cLppDataAccess.LPP_LOGISTI K_EISENBIEGEN%3e" target="_blank" rel="noreferrer">http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_auftraege:System.Linq.IQueryable%3cLppDataAccess.LPP_LOGISTI
K_EISENBIEGEN%3e>  = this._ctx
<<a href="http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities" target="_blank" rel="noreferrer">http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .GetOffeneEisenAuftraege
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities/GetOffeneEisenAuftraege():System.Linq.IQue
ryable%3cLppDataAccess.LPP_LOGISTIK_EISENBIEGEN%3e> ();



Questions:

a) Is the method described above considered as good practice?

b) Basically it is a connected Context until the user refreshes the data. In
this case the context is recreated.

c) In order to manage multiuser environment, do I need to work generally
with disconnected entities?

d) Do I need to dispose the the context on closing the window?



Thanks



Niko

-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140

------------------------------

_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


End of Firebird-net-provider Digest, Vol 119, Issue 2
*****************************************************



--
  Regards,
  Lt Col (Retd) Rajiv D.S. Chauhan
_____________________________

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: How to backup the remote database to a local hard disk

Mark Rotteveel-2
On 25-3-2016 17:23, LtColRDSChauhan wrote:
> Mark, thanks for your help.
> I was using FBackup.
>
>     FbStreamingBackup if you want to backup to your local machine.
>
> Using FbStreamingBackup solved my problem.
> But the ServiceOutput event handler is now not getting called.

That is expected, because there can't be any logging when using the
streaming backup. The channel that in FbBackup is used to get log
information is not available, because instead the backup data is sent
over that channel.

Mark
--
Mark Rotteveel

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: How to backup the remote database to a local hard disk

Nikolaus Kern
Hello,

is there any possibility to track the progress of the backup from the remote
machine?

Thanks

Niko

-----Ursprüngliche Nachricht-----
Von: Mark Rotteveel [mailto:[hidden email]]
Gesendet: Freitag, 25. März 2016 17:30
An: For users and developers of the Firebird .NET providers
<[hidden email]>
Betreff: Re: [Firebird-net-provider] How to backup the remote database to a
local hard disk

On 25-3-2016 17:23, LtColRDSChauhan wrote:
> Mark, thanks for your help.
> I was using FBackup.
>
>     FbStreamingBackup if you want to backup to your local machine.
>
> Using FbStreamingBackup solved my problem.
> But the ServiceOutput event handler is now not getting called.

That is expected, because there can't be any logging when using the
streaming backup. The channel that in FbBackup is used to get log
information is not available, because instead the backup data is sent over
that channel.

Mark
--
Mark Rotteveel

----------------------------------------------------------------------------
--
Transform Data into Opportunity.
Accelerate data analysis in your applications with Intel Data Analytics
Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: How to backup the remote database to a local hard disk

Jiří Činčura-2
> is there any possibility to track the progress of the backup from the
> remote
> machine?

No. Only data are flowing.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider