Taking backup of the database dynamically in Asp.Net. Here is another method to do so.
using
System;
using
System.Collections.Generic;
using
System.Collections;
using
System.Data;
using
System.Text;
using
System.Windows.Forms;
using
SourceEdge.BaseEntities;
using
SourceEdge.BCL;
using
SourceEdge.BaseEntities.Model;
using
RoadLines.Model;
using
System.Data.Sql;
using
System.Data.SqlClient;
using
System.Data.SqlTypes;
using
System.Configuration;
namespace
RoadLines
{
public partial class Frm_Databackup : Form
{
public Frm_Databackup()
{
InitializeComponent();
}
private void btnBack_Click(object sender, EventArgs e)
{
exeStoreProcedure();
this.Close();
}
private void btnCancel_Click(object sender, EventArgs e)
{
this.Close();
}
public void exeStoreProcedure()
{
SqlConnection con =
null;
try
{
string path = System.Configuration.ConfigurationManager.ConnectionStrings[2].ConnectionString;
con =
new SqlConnection(path);
con.Open();
SqlCommand cmd =
new SqlCommand("Exec sp_BackupDatabase 'RoadLines','F'");
cmd.CommandTimeout = 120;
cmd.Connection = con;
cmd.ExecuteNonQuery();
MessageBox.Show(
"Database backup successfull");
}
catch (Exception exp)
{
MessageBox.Show(
"Database backup Unsuccess");
MessageBox.Show(exp.ToString());
}
finally
{
if (con != null)
{
con.Close();
}
}
}
}
}