C#使用SQL语句备份跟恢复数据库

//备份数据库
[HttpGet]
public bool BackupDB()
{
bool a = false;
SqlConnection conn = new SqlConnection(DbHelper.ConnectionString);
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database DB_QA_TZ to disk='F:DataBaseDB_QA_TZ.bak'";
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
a = true;
}
catch (Exception ex)
{
}
finally
{
conn.Close();
conn.Dispose();
}
return a;
}
//还原数据库
[HttpGet]
public bool RecoveryDB()
{
HttpContext context = HttpContext.Current;
//获取数据库的路径跟名称
var path = context.Request.QueryString["path"].ToString();
var UserName = context.Request.QueryString["UserName"].ToString();
bool b = false;
SqlConnection conn = new SqlConnection(DbHelper.ConnectionString);
conn.Open();
SqlCommand cmdRT = new SqlCommand();
cmdRT.CommandType = CommandType.Text;
cmdRT.Connection = conn;
cmdRT.CommandText = @"restore database DB_QA_TZ from disk='" + path + "' WITH REPLACE";
try
{
cmdRT.ExecuteNonQuery();
b = true;
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return b;
}

最后

以上就是成就奇异果为你收集整理的C#使用SQL语句备份跟恢复数据库的全部内容，希望文章能够帮你解决C#使用SQL语句备份跟恢复数据库所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。