How to backup and restore database using code fast in ASP.NET MVC

Question

1.00/5 (2 votes)

See more:

In my asp.net web application, i want to add button to backup my project database. now i want to click backup button then a "myDB.bak" file stored in in computer. how can i do it. how can i do it for code fast method in asp.net mvc.

What I have tried:

C#

Public ActionResult BackupDatabase()
        {
var dbPath = Server.MapPath("~/App_Data/DBBackup.bak");
using (var db = new ProjectDbContext())
        {
var cmd = String.Format("BACKUP DATABASE {0} TO DISK='{1}' WITH FORMAT, MEDIANAME='DbBackups', MEDIADESCRIPTION='Media set for {0} database';"
                            , "YourDB", dbPath);
db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd);
                    }

Posted 2-Dec-16 1:17am

Member 12702853

Updated 2-Dec-16 2:32am

Add a Solution

Comments

Ehsan Sajjad 2-Dec-16 7:32am

what is happening right now with this way?

Philippe Mori 2-Dec-16 10:58am

You probably don't want backup/restore code to be in your ASP.NET MVC code. How would you do a restore when the site is not working because the database is corrupted. Obviously, you don't want to show such command to all users and thus the site would depends on the logged user which will typically depends on a working database.

1 solution

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)

OriginalGriff · Answer 1 · 2016-12-02T02:32:00

Solution 1

Or, you could do this: Backing up an SQL Database in C#[^]

Posted 2-Dec-16 2:32am

OriginalGriff