save backup of database using asp.net application(C#)

Question

0.00/5 (No votes)

See more:

I want to take a backup of my database in asp.net application.
When i save it, it should replace with previous one.
How can i do this?

Posted 23-May-11 2:34am

Darshan Gite

Updated 23-May-11 4:43am

thatraja

v2

Add a Solution

7 solutions

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)

Chandan Prasad Das · Answer 1 · 2011-05-23T03:21:00

Class BackupDbTask.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using Microsoft.Build.Framework;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;


    public class BackupDbTask
    {


        private string _sqlserverUser;
        public string SQLServerUser
        {
            get { return _sqlserverUser; }
            set { _sqlserverUser = value; }
        }
        private string _sqlserverPassword;
        public string SQLServerPassword
        {
            get { return _sqlserverPassword; }
            set { _sqlserverPassword = value; }
        }
        private string _sqlserverInstanceName;
        public string SqlServerInstanceName
        {
            get { return _sqlserverInstanceName; }
            set { _sqlserverInstanceName = value; }
        }
        private string _sqlserverDBName;
        public string SqlServerDBName
        {
            get { return _sqlserverDBName; }
            set { _sqlserverDBName = value; }
        }

        private string _databaseBackupFolder;

        public string DatabaseBackupFolder
        {
            get { return _databaseBackupFolder; }
            set { _databaseBackupFolder = value; }
        }

        private string _backupFile;

        public string BackupFile
        {
            get { return _backupFile; }
            set { _backupFile = value; }
        }
        #endregion Properties

        public void Execute()
        {

            // Backup Db
            try
            {
                ServerConnection conn = new ServerConnection();
                conn.LoginSecure = false;
                conn.DatabaseName = this.SqlServerDBName;
                conn.ServerInstance = this.SqlServerInstanceName;
                conn.Login = this.SQLServerUser;
                conn.Password = this.SQLServerPassword;
                Server svr = new Server(conn);
                Database BuildDB = svr.Databases[this.SqlServerDBName];

                string dbbackupfile = this.DatabaseBackupFolder + @"\" + this.SqlServerDBName + ".bak"; ;


                Backup backup = new Backup();
                backup.Database = this.SqlServerDBName;
                backup.MediaName = "FileSystem";
                BackupDeviceItem bkpDeviceItem = new BackupDeviceItem();
                bkpDeviceItem.DeviceType = DeviceType.File;
                bkpDeviceItem.Name = dbbackupfile;
                backup.Devices.Add(bkpDeviceItem);
                backup.Initialize = true;
                backup.SqlBackup(svr);

                this.BackupFile = dbbackupfile;
            }
            catch (Exception ex)
            {


            }


        }
    }

Class RestoreDBTask.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using Microsoft.Build.Framework;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

    public class RestoreDBTask 
    {
        #region Properties
       
        private string _sqlserverUser;
        
        public string SQLServerUser
        {
            get { return _sqlserverUser; }
            set { _sqlserverUser = value; }
        }
        private string _sqlserverPassword;
        public string SQLServerPassword
        {
            get { return _sqlserverPassword; }
            set { _sqlserverPassword = value; }
        }
        private string _sqlserverInstanceName;
      
        public string SqlServerInstanceName
        {
            get { return _sqlserverInstanceName; }
            set { _sqlserverInstanceName = value; }
        }
        private string _sqlserverDBName;
      
        public string SqlServerDBName
        {
            get { return _sqlserverDBName; }
            set { _sqlserverDBName = value; }
        }
        
        private string _backupFileFolder;
        public string BackupFileFolder
        {
            get { return _backupFileFolder; }
            set { _backupFileFolder = value; }
        }
       
        
        private string _backupFile;
        public string BackupFile
        {
            get { return _backupFile; }
            set { _backupFile = value; }
        }
        #endregion Properties
        public bool Execute()
        {
           

            ServerConnection conn = new ServerConnection();
            conn.LoginSecure = false;
            conn.DatabaseName = "Master";
            conn.ServerInstance = this.SqlServerInstanceName;
            conn.Login = this.SQLServerUser;
            conn.Password = this.SQLServerPassword;
            Server svr = new Server(conn);
            Database db = svr.Databases["Master"];
            string dbbackupfile = string.Empty;
            if (this.BackupFile == string.Empty)
                dbbackupfile = this.BackupFileFolder + @"\" + this.SqlServerDBName + ".bak";
            else
                dbbackupfile = this.BackupFile; 
            try
            {
                // Restore Database
                Restore restore = new Restore();
                restore.Database = this.SqlServerDBName;
                restore.RestrictedUser = true; 
                restore.Action = RestoreActionType.Database;
                restore.ReplaceDatabase = true;
                restore.Devices.AddDevice(dbbackupfile, DeviceType.File);
                svr.KillAllProcesses(this.SqlServerDBName);
                restore.Wait();  
                restore.SqlRestore(svr);
            }
            catch (Exception ex)
            {
                "Database restore failed", ex.InnerException.Message)
            }
            
        }
    }

PaRush · Answer 2 · 2011-05-23T05:26:00

Here is a simple codesnippet which displays a list of databases in a listbox.
The BackupNow() method backups the selected database in the disk. The backup path is specified in
the appsettings section in the web.config.

 GetConnection conn = new GetConnection();
 
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadHeader();
            PopulateDatabaseTables();             
            GetBackupList();
           
        }
    }
 private void PopulateDatabaseTables()
    {
        string tableName = string.Empty;
        string sql = "select distinct db_name(s_mf.database_id) AS database_name"+    
                        " from sys.master_files s_mf where s_mf.state = 0 ";
        using (SqlConnection DBConn = conn.GetDBCon())
        {
            using (DataTable databases = new DataTable())
            {
                using (SqlDataAdapter dAd = new SqlDataAdapter(sql, DBConn))
                {
                    dAd.Fill(databases);
                }
                ListBox1.DataSource = databases;
                ListBox1.DataTextField = "database_name";
                ListBox1.DataBind();
            }
        }
    }
	
	protected void BackUpNow(object sender, EventArgs e)
    {
        string tableName = this.ListBox1.SelectedItem.ToString();
        string date = DateTime.Now.ToShortDateString();
        date = date.Replace("/", "-");
        date = date.Replace(" ", ":");
		
        string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();        
           
        using ( SqlConnection DBConn = conn.GetDBCon())
        {
            string query = "backup database @tableName To Disk='" + path + "\\" + tableName + "[" + date + "]" + ".bak'";
            SqlCommand cmd = new SqlCommand(query, DBConn);
            cmd.Parameters.Add(new SqlParameter("@tableName", tableName));           
            cmd.ExecuteNonQuery();  
        }
        GetBackupList();
        lblMessage.Text = "Backup for  <b>Database</b> successful!";
    }
	
	public void GetBackupList()
    {
        string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();
        DirectoryInfo diFiles = new DirectoryInfo(path);        
        backupList.DataSource = diFiles.GetFiles("*.bak");       
        backupList.DataBind(); 
    }

PaRush · Answer 3 · 2011-05-23T05:28:00

Here is a simple codesnippet which displays a list of databases in a listbox.
The BackupNow() method backups the selected database in the disk. The backup path is specified in
the appsettings section in the web.config.

 GetConnection conn = new GetConnection();
 
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadHeader();
            PopulateDatabaseTables();             
            GetBackupList();
           
        }
    }
 private void PopulateDatabaseTables()
    {
        string tableName = string.Empty;
        string sql = "select distinct db_name(s_mf.database_id) AS database_name"+    
                        " from sys.master_files s_mf where s_mf.state = 0 ";
        using (SqlConnection DBConn = conn.GetDBCon())
        {
            using (DataTable databases = new DataTable())
            {
                using (SqlDataAdapter dAd = new SqlDataAdapter(sql, DBConn))
                {
                    dAd.Fill(databases);
                }
                ListBox1.DataSource = databases;
                ListBox1.DataTextField = "database_name";
                ListBox1.DataBind();
            }
        }
    }
	
	protected void BackUpNow(object sender, EventArgs e)
    {
        string tableName = this.ListBox1.SelectedItem.ToString();
        string date = DateTime.Now.ToShortDateString();
        date = date.Replace("/", "-");
        date = date.Replace(" ", ":");
		
        string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();        
           
        using ( SqlConnection DBConn = conn.GetDBCon())
        {
            string query = "backup database @tableName To Disk='" + path + "\\" + tableName + "[" + date + "]" + ".bak'";
            SqlCommand cmd = new SqlCommand(query, DBConn);
            cmd.Parameters.Add(new SqlParameter("@tableName", tableName));           
            cmd.ExecuteNonQuery();  
        }
        GetBackupList();
        lblMessage.Text = "Backup for  <b>Database</b> successful!";
    }
	
	public void GetBackupList()
    {
        string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();
        DirectoryInfo diFiles = new DirectoryInfo(path);        
        backupList.DataSource = diFiles.GetFiles("*.bak");       
        backupList.DataBind(); 
    }

PaRush · Answer 4 · 2011-05-23T05:30:00

Here is a simple codesnippet which displays a list of databases in a listbox.
The BackupNow() method backups the selected database in the disk. The backup path is specified in
the appsettings section in the web.config.

protected void BackUpNow(object sender, EventArgs e)
{
    string tableName = this.ListBox1.SelectedItem.ToString();
    string date = DateTime.Now.ToShortDateString();
    date = date.Replace("/", "-");
    date = date.Replace(" ", ":");

    string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();

    using ( SqlConnection DBConn = conn.GetDBCon())
    {
        string query = "backup database @tableName To Disk='" + path + "\\" + tableName + "[" + date + "]" + ".bak'";
        SqlCommand cmd = new SqlCommand(query, DBConn);
        cmd.Parameters.Add(new SqlParameter("@tableName", tableName));
        cmd.ExecuteNonQuery();
    }
    GetBackupList();
    lblMessage.Text = "Backup for  <b>Database</b> successful!";
}

public void GetBackupList()
{
    string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();
    DirectoryInfo diFiles = new DirectoryInfo(path);
    backupList.DataSource = diFiles.GetFiles("*.bak");
    backupList.DataBind();
}

PaRush · Answer 5 · 2011-05-23T05:32:00

Here is a simple codesnippet which displays a list of databases in a listbox.
The BackupNow() method backups the selected database in the disk. The backup path is specified in
the appsettings section in the web.config.

GetConnection conn = new GetConnection();


private void PopulateDatabaseTables()
   {
       string tableName = string.Empty;
       string sql = "select distinct db_name(s_mf.database_id) AS database_name"+
                       " from sys.master_files s_mf where s_mf.state = 0 ";
       using (SqlConnection DBConn = conn.GetDBCon())
       {
           using (DataTable databases = new DataTable())
           {
               using (SqlDataAdapter dAd = new SqlDataAdapter(sql, DBConn))
               {
                   dAd.Fill(databases);
               }
               ListBox1.DataSource = databases;
               ListBox1.DataTextField = "database_name";
               ListBox1.DataBind();
           }
       }
   }

   protected void BackUpNow(object sender, EventArgs e)
   {
       string tableName = this.ListBox1.SelectedItem.ToString();
       string date = DateTime.Now.ToShortDateString();
       date = date.Replace("/", "-");
       date = date.Replace(" ", ":");

       string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();

       using ( SqlConnection DBConn = conn.GetDBCon())
       {
           string query = "backup database @tableName To Disk='" + path + "\\" + tableName + "[" + date + "]" + ".bak'";
           SqlCommand cmd = new SqlCommand(query, DBConn);
           cmd.Parameters.Add(new SqlParameter("@tableName", tableName));
           cmd.ExecuteNonQuery();
       }
       GetBackupList();
       lblMessage.Text = "Backup for  <b>Database</b> successful!";
   }

   public void GetBackupList()
   {
       string path = ConfigurationManager.AppSettings.Get("DBBackupPath").ToString();
       DirectoryInfo diFiles = new DirectoryInfo(path);
       backupList.DataSource = diFiles.GetFiles("*.bak");
       backupList.DataBind();
   }

muthukkumaran Kaliyamoorthy · Answer 6 · 2011-05-30T19:48:00

Solution 7

@ambarishtv Thanks for suggesting my blog post.

Posted 30-May-11 19:48pm

muthukkumaran Kaliyamoorthy

ambarishtv · Answer 7 · 2011-05-23T05:02:00

Solution 2

Database backup & Restore using T-SQL
Link[^]

Posted 23-May-11 5:02am

ambarishtv

Updated 23-May-11 5:09am

v2

save backup of database using asp.net application(C#)

7 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 6

Solution 7

Solution 2

Add your solution here

Preview 0