Saturday, December 12, 2009

Sql Server Data Base Back Up Using C#

private void btnBackUp_Click(object sender, EventArgs e)
{

bool bBackUpStatus = true;
Cursor.Current = Cursors.WaitCursor;

string path="D:\\SQLBackup";
//string path = Environment.GetFolderPath(System.Environment.SpecialFolder.System);

string path1,path2=path ;

string date = System.DateTime.Today.Day.ToString() + System.DateTime.Today.Month.ToString() + System.DateTime.Today.Year .ToString();

string backupname = "\\wcBackUp1.bak";
if (Directory.Exists(@path))
{
path = path + "\\" + date;
path1 = path + "\\";
if (Directory.Exists(@path))
{
path = path + "\\" + backupname;
}
else
{
Directory.CreateDirectory(@path);
path = path + "\\" + backupname;
}

//if (System.IO.File.Exists(@path))
//{
// if (MessageBox.Show(@"Do you want to replace it?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
// {

// System.IO.File.Delete(@path);
// }
// else
// bBackUpStatus = false;
//}
}
else
{
Directory.CreateDirectory(@path2);
path = path + "\\" + date;
path1 = path + "\\";
if (Directory.Exists(@path))
{
path = path + "\\" +backupname;
}
else
{
Directory.CreateDirectory(@path);
path = path + "\\" + backupname;
}

if (System.IO.File.Exists(@path))
//@"c:\SQLBackup\wcBackUp1.bak"))
{
scount++;
//if (MessageBox.Show(@"Do you want to replace it?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
//{

// System.IO.File.Delete(@path1);
//}
//else
// bBackUpStatus = false;
}
}

if (scount == 0)
{
//Connect to DB
SqlConnection connect;
string con = Helper.ConnectionString.ToString();
connect = new SqlConnection(con);
connect.Open();
//----------------------------------------------------------------------------------------------------
//Execute SQL---------------
SqlCommand command;
command = new SqlCommand(@"backup database HealthManagement to disk ='" + path + "'", connect);
command.ExecuteNonQuery();
//-------------------------------------------------------------------------------------------------------------------------------
connect.Close();
MessageBox.Show("The support of the database was successfully performed", "Back", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("BackUp Already Taken For Today","Back", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

}

No comments:

Post a Comment