How to get backup & restore the database in c#

Question

0.00/5 (No votes)

See more:

Hi,

I have an appliaction in c#. & I am using SQL server 2005. I stored the database in bin\debug\App_Data folder.

I want to get the back of my database when I click on backup_button. & restore the database in given location when click on restore_button.

Thanks in advance.

Posted 3-Oct-11 17:27pm

deepakjagd

Add a Solution

4 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)

Al Moje · Answer 1 · 2011-10-03T17:38:00

Hi,

Try this for backup:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Data.SqlClient;
namespace Utilities
{
    public class Backup
    {
        public virtual bool MyFile(string targetSavePath, string catalogDb, string bConnToBackup)
        {
            //Author: Algem Mojedo
            bool retValue = false;
            DirectoryInfo dirInfo = new DirectoryInfo(targetSavePath);
            if (!dirInfo.Exists)
            {
                return retValue;
            }
            string todayIs = DateTime.Today.ToShortDateString().Trim().Replace("/", "-") + ".bak";
            StringBuilder sb = new StringBuilder();
            sb.Append(" USE MASTER " + "\r\n ");
            sb.Append(" DECLARE @fileName VARCHAR(50) " + "\r\n ");
            sb.Append(" DECLARE @fileDate VARCHAR(20)  " + "\r\n  ");
            sb.Append(" DECLARE @path VARCHAR(220)  " + "\r\n  ");
            sb.Append("\r\n ");
            sb.Append(" SET @path =  '" + targetSavePath + "'\r\n ");
            sb.Append(" SET @fileName = '" + catalogDb + "'\r\n ");
            sb.Append(" SELECT @fileDate = CONVERT(VARCHAR(20), GETDATE(),112) " + "\r\n "); //-- Fetching today's data
            sb.Append(" DECLARE db_cursor CURSOR FOR " + "\r\n ");
            sb.Append(" SELECT name FROM dbo.sysdatabases WHERE name IN ('" + catalogDb + "') " + "\r\n ");
            sb.Append(" OPEN db_cursor   FETCH NEXT FROM db_cursor INTO @fileDate " + "\r\n ");
            sb.Append(" WHILE @@FETCH_STATUS = 0   BEGIN  " + "\r\n ");
            sb.Append(" SET @fileName = @path + @fileDate + '_" + todayIs + "' \r\n ");
            sb.Append(" BACKUP DATABASE @fileDate TO DISK = @fileName " + "\r\n ");
            sb.Append(" FETCH NEXT FROM db_cursor INTO @fileDate  END " + "\r\n ");
            sb.Append(" CLOSE db_cursor   DEALLOCATE db_cursor " + "\r\n ");
            string sbStr = sb.ToString();
            string adCon = string.Empty;
            if (!(bConnToBackup.ToLower().Contains("timeout")))
            {
                adCon = ";Connect Timeout=300; pooling='true'; Max Pool Size=300";
            }
            SqlConnection conn = new SqlConnection((bConnToBackup + adCon));
            SqlCommand cmd = new SqlCommand(sbStr);
            try
            {
                cmd.Connection = conn;
                cmd.Connection.Open();
                cmd.CommandTimeout = 300;
                cmd.ExecuteScalar();
                retValue = true;
            }
            catch (Exception)
            {
                retValue = false;
                return retValue;
            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }
            return retValue;
        }
    }
}

Remember to vote on this if help...

Regards,

Algem

arunrv · Answer 2 · 2011-10-03T22:18:00

Solution 2

view this link this might may help u

SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]

Posted 3-Oct-11 22:18pm

arunrv

devildx2050 · Answer 3 · 2011-10-04T00:05:00

Solution 3

refer these links

http://www.dotnetspider.com/forum/162986-database-backup-restore-through-C.aspx[^]

from the link below you got sample code....

http://midnightprogrammer.net/post/BackupRestore-SQL-database-using-C.aspx[^]

Posted 4-Oct-11 0:05am

devildx2050

ManavGuru · Answer 4 · 2011-10-04T00:38:00

This is for backup

C#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Windows.Forms;
using System.IO;
using System.Collections.Generic;
using System.Data.SqlClient;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common; 
     
  {
            SaveFileDialog saveFileDlg = new SaveFileDialog();
            saveFileDlg.Filter = "Mircosoft Access Files(*.mdb)|*.mdb";
            saveFileDlg.Title = "Create Invoice Backup";
            saveFileDlg.RestoreDirectory = false;
            if (saveFileDlg.ShowDialog() == DialogResult.OK)
            {

                string sourceFile = Application.StartupPath.ToString() + "\\InvoiceGenerator.mdb";

                string DatabaseName = saveFileDlg.FileName;
                string img = "Images";
                string sourcePath = (Application.StartupPath + "/Images/");
                string targetPath = DatabaseName.Replace(DatabaseName, img);
                try
                {
                    File.Copy(sourceFile, DatabaseName);
                    MessageBox.Show("Backup Create Successfully");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                if (!System.IO.Directory.Exists(targetPath))
                {
                    System.IO.Directory.CreateDirectory(targetPath);
                }

                if (System.IO.Directory.Exists(sourcePath))
                {
                    string[] files = System.IO.Directory.GetFiles(sourcePath);
                    string fileName;
                    string destFile;
                    foreach (string s in files)
                    {
                        fileName = System.IO.Path.GetFileName(s);
                        destFile = System.IO.Path.Combine(targetPath, fileName);
                        System.IO.File.Copy(s, destFile, true);
                    }
                }
                else
                {
                    MessageBox.Show("Source path does not exist!");
                }


            }
        }


//..................THis Is For Restore.........................

        {
            string message = "After Restoring the Database from a previous Backup, Current Database will be lost and the changes made after Backup will become unrecoverable. Are you sure you want to Continue!";
            string caption = "Restore Backup";
            DialogResult result;
            string img;
            img = AppDomain.CurrentDomain.BaseDirectory + "database_add_48.png";

            //MessageBox.Show(message, caption, MessageBoxButtons.YesNo);
            result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);

            if (result == DialogResult.Yes)
            {

                OpenFileDialog openDlg = new OpenFileDialog();
                openDlg.Filter = "DataBase Files (*.mdb)|*.mdb";
                openDlg.FileName = "";
                openDlg.DefaultExt = ".mdb";
                openDlg.CheckFileExists = true;
                openDlg.CheckPathExists = true;
                DialogResult res = openDlg.ShowDialog();
                if (res == DialogResult.OK)
                {
                    if (!(openDlg.FileName).EndsWith(".mdb") && !(openDlg.FileName).EndsWith(".MDB"))
                        MessageBox.Show("Invalid file format...!", "Prajeesh", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    else
                    {
                        string sourceFile = Application.StartupPath.ToString() + "\\InvoiceGenerator.mdb";

                        string DatabaseName = openDlg.FileName;
                        try
                        {
                            //File.Delete(sourceFile);
                            // File.Copy(DatabaseName, sourceFile);


                            File.Copy(DatabaseName, sourceFile, true);


                            MessageBox.Show("Restore Successfully");
                            // pictureBox3.ImageLocation = img;
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }

                    }
                }

            }
        }

How to get backup & restore the database in c#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0