How to take backup sql server database through ASP.NET & C#.NET

Itsmemohanr
Posted by in ADO.NET category on for Intermediate level | Points: 250 | Views : 45816 red flag
Rating: 5 out of 5  
 2 vote(s)

In this article I am going to explain how to take backup of your database from ASP.NET or from C#.NET.

Introduction

In this article I am going to explain how to take backup of your database either from ASP.NET or C#.NET.


Objective

Backup of your database either from ASP.NET or C#.NET



Using the code



Default.aspx Code Behind

using System.Data;
using System.Data.SqlClient;
using System.IO;

public partial class _Default : System.Web.UI.Page
{
//Metioned here your database name
string dbname = "test1";
SqlConnection sqlcon=new SqlConnection();
SqlCommand sqlcmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
//Mentioned Connection string make sure that user id and password sufficient previlages
sqlcon.ConnectionString = @"Server=MOHANDB\SQLEXPRESS;database=" + dbname + ";uid=ravindran;pwd=srirangam;";

//Enter destination directory where backup file stored
string destdir = "D:\\backupdb";

//Check that directory already there otherwise create
if (!System.IO.Directory.Exists(destdir))
{
System.IO.Directory.CreateDirectory("D:\\backupdb");
}
try
{
//Open connection
sqlcon.Open();
//query to take backup database
sqlcmd = new SqlCommand("backup database test to disk='" + destdir + "\\" + DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".Bak'", sqlcon);
sqlcmd.ExecuteNonQuery();
//Close connection
sqlcon.Close();
Response.Write("Backup database successfully");
}
catch (Exception ex)
{
Response.Write("Error During backup database!");
}
}
}

In C#.NET Windows application 

using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Windows.Forms;

namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
//Metioned here your database name
string dbname = "test1";
SqlConnection sqlcon=new SqlConnection();
SqlCommand sqlcmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

//Mentioned Connection string make sure that user id and password sufficient previlages
sqlcon.ConnectionString = @"Server=RAVI-PC\SQLEXPRESS;database=" + dbname + ";uid=ravindran;pwd=srirangam;";

//Enter destination directory where backup file stored
string destdir = "D:\\backupdb";

//Check that directory already there otherwise create
if (!System.IO.Directory.Exists(destdir))
{
System.IO.Directory.CreateDirectory("D:\\backupdb");
}
try
{
//Open connection
sqlcon.Open();
//query to take backup database
sqlcmd = new SqlCommand("backup database " + dbname + " to disk='" + destdir + "\\" + DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".Bak'", sqlcon);
sqlcmd.ExecuteNonQuery();
//Close connection
sqlcon.Close();
MessageBox.Show("Backup database successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error During backup database!");
}
}
}
}

1. Now Build that windows application in bin directory .exe file automatically created.
2. Go to control panel choose scheduled task -> Add Schedule task choose that exe file and select which data that exe run after that your database backup automatically created every day and stored in specified location.

Output 

Check the D:\backupdb directory the database backup created automatically. 

Conclusion

I hope this article helps you to learn take database in easy way. 



Page copy protected against web site content infringement by Copyscape

About the Author

Itsmemohanr
Full Name: Mohan Rajendran
Member Level: Starter
Member Status: Member
Member Since: 8/21/2012 3:26:31 AM
Country: India
R.Mohan Flextronics
http://www.dotnetfunda.com

Login to vote for this post.

Comments or Responses

Posted by: Ksuresh on: 9/3/2012 | Points: 25
Hi Mohan Rajendran,

Thanks, Very good Article, it worked for me

Please provide me for MySql Database.

Thanks and Regards
Suresh

Login to post response

Comment using Facebook(Author doesn't get notification)