Backup of the database in entity framework

Question

4.00/5 (1 vote)

See more:

, +

Hello
I work with entity framework. my db files in a directory.
I want get backup the database files. What software do move these two files?
This program is run when files are locked.
Is there any way other than copying files?

Posted 21-Aug-11 21:23pm

esmailian

Add a Solution

Comments

Keith Barrow 22-Aug-11 3:26am

Is there any reason you can't just backup the database normally, without involving the entity framework?

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TheyCallMeMrJames · Answer 1 · 2011-08-22T09:14:00

Solution 1

If you are using MDBs then they will always be locked when in use. One way to do it would be to write a whackload of stored procs, wrap them with a 'backup' proc and call that from the client.

Consider using SQL 2008 Express, and host the DB there. That way you would be able to create backup maintenance plans, have other servers pull the data, etc. Lots of options. You can even use SQL Server Management Studio to do the backups by hand.

Cheers.

Posted 22-Aug-11 9:14am

TheyCallMeMrJames

Updated 22-Aug-11 9:15am

v2

Comments

esmailian 23-Aug-11 5:36am

my file extension is .mdf .but my db file not attach in SQL server . my connect to file and I need a trick to copy this file when my program run .

TheyCallMeMrJames 23-Aug-11 11:00am

I'm sorry, esmailian, you're trying to do something that is designed not to happen here. Can you not figure a different approach? If the file is locked, it's locked. The OS won't let you carry the operation out. EF is not going to enable you to do this. You will likely need to write some really low level unmanaged code to do this.

Edit: read new answer below for one possible option. /eatingCrow

TheyCallMeMrJames · Answer 2 · 2011-08-23T05:04:00

Solution 2

I'm going to backtrack a bit...as it turns out you can use the shadow copy approach, but it may not fit your needs as you've described above. Certainly, it cannot be done with EF.

http://www.codeproject.com/KB/dotnet/makeshadowcopy.aspx?display=Print
Cheers.

Posted 23-Aug-11 5:04am

TheyCallMeMrJames

Updated 10-Sep-11 0:38am

v2

Comments

esmailian 23-Aug-11 15:22pm

Thank TheyCallMeMrJames but I cant work with vb . I work c#

Rakesh Meel · Answer 3 · 2011-09-07T02:38:00

Solution 3

Volume Shadow Copies from .NET[^]

Posted 7-Sep-11 2:38am

Rakesh Meel

Updated 10-Sep-11 0:35am

v2

Member 7892182 · Answer 4 · 2014-01-23T20:14:00

Database backup is a part of Maintenance not part of programming so go to Maintenance Plan feature of SQL server Management Studio.

How to: Create a Maintenance Plan, use :http://msdn.microsoft.com/en-us/library/ms189953(v=sql.105).aspx[^]

If you are using Express Editon (thus no SQL Server Agent is available for Maintenance Plan) see script given by ; http://ola.hallengren.com/[^] , Here free script is given.

Backup of the database in entity framework

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us