Generate database backup via application

Question

In my project I connect to the database.

Is there any way I can do the backup from my database via Asp.net mvc 5 and keep that backup in a directory, either at the project root or in a folder in a safer place?

The database I use is the SQL Server Express 2012.

Answer 1

It is possible yes. You need to mount in your C# code the sql command of backup and run it, something like:

Open the connection and mount a query which executes the command to do the backup as the desired way to save your backup

public void ExecutarBackup(string caminho)
{ 
    suaConexao = new SqlConnection(...);
    var query = "Backup database NomeSeuBanco to disk='" + caminho + "'";
    var cmd = new SqlCommand(query, suaConexao);
    cmd.ExecuteNonQuery();
}

---

Edition/Complement:

And how would I put it in a view ? Like a button ? Or something like that.

Your View can have a control for the user to inform the path in which he wants to save the backup and a button. When clicking the button occurs the Post for a Action of your Controller, passing the path the user wants to save the backup as a parameter.

That one Action can call a service/method to generate the backup.

[HttpPost]
public ActionResult SalvarBakup(SeuViewModel seuViewModel)
{
    _servicoBackup.ExecutarBackup(seuViewModel.Caminho);
    return View();
}

Below exemplifies the View:

@model SeuViewModel

@using (Html.BeginForm("SalvarBakup", "SeuController"))
{
    @Html.TextBoxFor(model => model.Caminho)
    <input type="submit" value="Salvar Backup" />
}