How to show progress bar during sql server database backup in c# .net windows application?

Question

5.00/5 (1 vote)

See more:

.NET3.5

, +

Hello,

I am creating windows application for create sql server database backup.
It's have done successfully but i want to show progress bar during create database backup in local drive.

my code is:-

C#

string dbName="abc";
SqlConnection con = new SqlConnection(cnString1);
string DestDir = @"C:\DatabaseBackup";
if (!System.IO.Directory.Exists(DestDir))
{
   System.IO.Directory.CreateDirectory(@"C:\DatabaseBackup");
}
try
{
   con.Open();
   SqlCommand cmd = new SqlCommand("BACKUP DATABASE " + dbName + " TO DISK='" + DestDir + "\\" + dbName + ".bak' WITH FORMAT", con);
   cmd.ExecuteNonQuery();

   con.Close();
   MessageBox.Show("Database Backup Created 'C:\\DatabaseBackup\' drive and folder ");

So,
How could that possible in this code?

Thank You.
Ankit Agarwal
Software Engineer

Posted 16-Jan-13 1:39am

ankit.agg1984

Updated 16-Jan-13 4:05am

Sandeep Mewara

v2

Add a Solution

Comments

Zoltán Zörgő 16-Jan-13 7:43am

You are using my answer: http://www.codeproject.com/Answers/525950/How-can-we-overwrite-of-existing-sql-server-data-b.aspx#answer1, but you have not accepted it :(

rastogi.siddharth 16-Jan-13 7:48am

Take help from this link, which is very nice article:-
http://www.codeproject.com/Articles/449594/Progress-Bars-Threads-Windows-Forms-and-You

Zoltán Zörgő 17-Jan-13 16:26pm

Any progress?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2013-01-16T01:47:00

Solution 1

Not this way, but with SMO, as I suggested before: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backuprestorebase.percentcomplete(v=sql.105).aspx[^], see also: example of SMO event handling[^]

Posted 16-Jan-13 1:47am

Zoltán Zörgő

**Joezer BH** · Answer 2 · 2013-01-19T22:04:00

Hi Ankit,

Good question (5+)
However, the answer is simply - No.
Getting events of the backup process is, currently not possible.
so you can't really get a progress bar for this.

[idea] Perhaps you might go around and (if you can estimate the backedup DB size) perform checks on the file size, and then show the estimation percentage on the GUI.

Using Zoltán's MSDN link is good for getting an event at the end, which is some indication but not of the process itself.

* if you do find a miraculous way to perform such a thing, do let us know, will you?

Cheers,
Edo

How to show progress bar during sql server database backup in c# .net windows application?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to show progress bar during sql server database backup in c# .net windows application?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us