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.

4 Comments

Join the conversation! Your thoughts help the community grow.

abdihakim ahmed9y ago
Its Nice Thanks but i want to create new back file
Ramesh Palanivel9y ago
WIndows will automatically replace the existing back up and will create it as new backup.. if u want to maintain existing backup and need to create a new backup, u can set datetime with filename, so the backup will be maintain date wise
Anil Kumar9y ago
It is updating existing backup , i want to create new back file
Upendra Pratap Shahi9y ago
Nice one....................