实现数据库的备份:
SqlConnection conn = new SqlConnection(connection);
string databaseName=@"E:\Data\Test.mdf"; //指定数据库名称(完整路径)
conn.Open();
string bakSQL = @"backup database @DataBaseName to disk=N'E:\Temp\Test.bak'"; //数据库备份SQL语句
try
{
SqlCommand cmd = new SqlCommand(bakSQL,conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@DataBaseName",databaseName); //参数
cmd.ExecuteNonQuery();
}
catch (Exception ee)
{
Console.WriteLine(ee);
}
数据库备份的还原:(待修改)
public static void Restore()
{
SqlConnection conn = new SqlConnection(connec