SQL Server 备份与复原

第一种方法用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