public void BackUp()
{
String str;
SqlConnection conn = new SqlConnection("Server=smiles;uid=sa;pwd=sa;Integrated security=SSPI;database=log1");
str = "BACKUP DATABASE log1 TO disk='\\cxc\007\northwind.bak'";//disk='d:\\aa\\a.bak'
SqlCommand command = new SqlCommand(str, conn);
try
{
conn.Open();
command.ExecuteNonQuery();
MessageBox.Show("backup Successfully");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
}
}
}