SQL Server DB Backup Using Stored Procedure In WinForm Application

In this article, we are going to learn the process of getting database backup using stored procedure in SQL Server using a C# WinForm application.

 

Let's see the steps to create the database backup file.

 

Step 1

 

First, we will create a database in SQL Server. Here, I have created the database and named it as "SampleDBTest".

 

Please find the below image for your reference.

 

 

 

Step 2

 

Let's create a stored procedure to take a back up on our local disk. To create a stored procedure, please refer to  the image.

 

 

 

Step 3

 

Let's write the query in the stored procedure to make a database backup file on the disk.

 

 

Please use the query if you need it.

create proc SqlDBBackup
as
begin
declare @path varchar(1000);
set @path='D:\Backup\SampleDBTest3'+CONVERT(CHAR(10),  GETDATE(), 121)+'.bak';
BACKUP DATABASE SampleDBTest to DISK=@path;
end

Once the procedure has been created, you can see your created stored procedure under "programmability" tab.

 

Step 4

 

Let's create a simple C# Windows application in Visual Studio.

 

To create a new Windows application in Visual Studio, go to Visual Studio -> New Project -> select "Windows" tab in the left pane (Note : choose the language C# or VB) -> name your project and click OK.

 

Now, you can see an empty Form window. Let's drag one button from the toolbox and change the label text to "Get DB Backup".

 

Please find the sample image here.

 

 

Step 5

 

Let's add our database to our project using "Add Connection" method.

 

 

Step 6

 

Let's create a connection string for our database in App.Config.

 

 

Step 7

 

Now, we will write the C# code for calling our stored procedure to take the database backup.

 

 

Please find the code  below.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;

namespace TextilePro
{
    public partial class frmWorkingForm : Form
    {
        public frmWorkingForm()
        {
            InitializeComponent();
        }
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TextileProConString"].ToString());
        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("SqlDBBackup", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("Back up Done successfully","SQLDB Backup",MessageBoxButtons.OK,MessageBoxIcon.Information);
        }
    }
}

Step 8

Let's run our project. To run it,  press ctrl+F5. Click "Get DB Backup button" and you will receive a success message, as shown in the image below.

 

 

Let's open our folder and check whether the database backup is created or not. Now, you can see your database backup file in the given directory.