C#使用SQL语句备份跟恢复数据库_c#是否可以直接通过sql还原数据库-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_43005276/article/details/113624714

本文介绍了一个简单的备份和还原数据库的方法，使用C#语言通过SqlCommand对象执行SQL命令来完成数据库DB_QA_TZ的备份到指定文件及从文件中还原回数据库的操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

      //备份数据库
        [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:\DataBase\DB_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;
        }