Tuesday, July 29, 2008

Backup Database using C#.net

private void button1_Click(object sender, EventArgs e)
{
BackUpDatabase("testdb", "D:\\1.bak");
}
public void BackUpDatabase(string DBname, string setBakUpPath)
{
SqlConnection sCon = new SqlConnection("Data Source=.; Initial Catalog=testdb; Integrated Security=true;");
SqlCommand sCom = new SqlCommand("BACKUP DATABASE " + DBname + " TO DISK = '" + setBakUpPath + "' WITH NOFORMAT, NOINIT, NAME = 'Full Database Backup', SKIP, NOREWIND, NOUNLOAD,STATS = 10", sCon);
sCom.CommandType = CommandType.Text;
try
{
sCon.Open();
sCom.ExecuteNonQuery();
MessageBox.Show("Database " + DBname + " : BackUp Done!", DBname + " BackUp", MessageBoxButtons.OK, MessageBoxIcon.Information);
sCon.Close();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString(), "Backup ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
sCom.Dispose();
}

No comments: