Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
 

Take SQL Server Data Base backup in ASP.NET

Article:
Viewed:  815 
Posted On:  22/10/2014 00:46:58 
How we can take Sql server Data Base backup uisng c# , asp.net ? How we can schedule a backup service in c# ? 

 

In this article I am going to explain how we can take backup of our Data Base using c#, asp.net.

Below is my output screen:

1.png

Image 1.

Below is my aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Backup and Restore DataBase</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table cellpadding="10" cellspacing="10" style="border: solid 10px red; background-color: Skyblue;"
            width="90%" align="center">
            <tr>
                <td style="height: 35px; background-color: Yellow; font-weight: bold; font-size: 16pt;
                    font-family: Times New Roman; color: Red" align="center">
                        Backup SQL Server DataBase
                </td>
            </tr>
            <tr>
                <td align="center">
                    <asp:Label ID="lblError" runat="server" ForeColor="Red"></asp:Label>
                </td>
            </tr>
            <tr>
                <td align="right">
                    <asp:Button ID="btnBackup" runat="server" Text="Backup DataBase" OnClick="btnBackup_Click" />
                </td>
 
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
 

My aspx.cs code is:

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
 
public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection();
    SqlCommand sqlcmd = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataTable dt = new DataTable();
 
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }

    
protected void btnBackup_Click(object sender, EventArgs e)
    {
        //IF SQL Server Authentication then Connection String
        //con.ConnectionString = @"Server=MyPC\SqlServer2k8;database=" + YourDBName + ";uid=sa;pwd=password;";
 
        //IF Window Authentication then Connection String
        con.ConnectionString = @"Server=MyPC\SqlServer2k8;database=Test;Integrated Security=true;";
 
        string backupDIR = "H:\\BackupDB";
        if (!System.IO.Directory.Exists(backupDIR))
        {
            System.IO.Directory.CreateDirectory(backupDIR);
        }
        try
        {
            con.Open();
            sqlcmd = new SqlCommand("backup database test to disk='" + backupDIR + "\\" + DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".Bak'", con);
            sqlcmd.ExecuteNonQuery();
            con.Close();
            lblError.Text = "Backup database successfully";
        }
        catch (Exception ex)
        {
            lblError.Text = "Error Occured During DB backup process !<br>" + ex.ToString();
        }
    }
}
 
Check your backup directory:
 
2.png

Image 2.

  Comment:
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us