备份:use master;backup database @name to disk=@path;
恢复:use master;restore database @name from disk=@path;
上面用的是参数化SQL语句,可以在程序执行的时候动态给参数赋值。
SqlCommand command = new SqlCommand("use master;backup database @name to disk=@path;",connection);
connection.Open();
string path=Server.MapPath("~\\App_Data")+"\\"+dbFileName;
command.Parameters.AddWithValue("@name", dbName);
command.Parameters.AddWithValue("@path", path);
command.ExecuteNonQuery();
connection.Close();