第一种方法用sql script.
GetDBConnection();
string sql =
@"USE [MASTER]
BACKUP DATABASE @DB TO DISK = @FILEPATH WITH INIT, DESCRIPTION = @DESCRIPTION";
using (var command = new SqlCommand(sql,this.con))
{
command.Parameters.AddWithValue("@DB",this.con.Database);
command.Parameters.AddWithValue("@FILEPATH",fullPath);
command.Parameters.AddWithValue("@DESCRIPTION",description);
command.CommandTimeout = 300;
command.ExecuteNonQuery();
}
string sql =
@"RESTORE DATABASE @DB FROM DISK = @FilePath WITH REPLACE,
MOVE @LogicName TO @PhysicalName,
MOVE @LogicLogName TO @PhysicalLogName";
using(var command = new SqlCommand(sql, this.con))
{
command.Parameters.AddWithValue("@DB", databasename);
command.Parameters.AddWithValue("@F