C#备份，还原数据库

    private void btnBack_Click(object sender, EventArgs e)
     {
         string saveAway = @"C:\1.bak";
         //            string cmdText = @"backup database " + System.Configuration.ConfigurationSettings.AppSettings["dbName"] + " to disk='" + saveAway + "'";
         string cmdText = @"backup database TestDemo to disk='" + saveAway + "'";
         BakReductSql(cmdText, true);
     }
 
     private void btnRestore_Click(object sender, EventArgs e)  //恢复
     {
         // string openAway = this.tbxReductLoad.Text.ToString().Trim();//读取文件的路径
         string openAway = @"c:\1.bak";//读取文件的路径
         //string cmdText = @"restore database " + System.Configuration.ConfigurationSettings.AppSettings["dbName"] + " from disk='" + openAway + "'";
         string cmdText = @"restore database TestDemo from disk='" + openAway + "' with REPLACE;";
         BakReductSql(cmdText, false);
     }
     /// <summary>
     /// 对数据库的备份和恢复操作，Sql语句实现
     /// </summary>
     /// <param name="cmdText">实现备份或恢复的Sql语句</param>
     /// <param name="isBak">该操作是否为备份操作，是为true否，为false</param>
     private void BakReductSql(string cmdText, bool isBak)
     {
         SqlCommand cmdBakRst = new SqlCommand();
         SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=master;uid=sa;pwd=sa;");
         try
         {
             conn.Open();
             cmdBakRst.Connection = conn;
             cmdBakRst.CommandType = CommandType.Text;
             if (!isBak)     //如果是恢复操作
             {
                 string setOffline = "Alter database TestDemo Set Offline With rollback immediate ;";
                 string setOnline = " Alter database TestDemo Set Online With Rollback immediate;";
                 cmdBakRst.CommandText = setOffline + cmdText + setOnline;
             }
             else
             {
                 cmdBakRst.CommandText = cmdText;
             }
             cmdBakRst.ExecuteNonQuery();
             if (!isBak)
             {
                 MessageBox.Show("恭喜你，数据成功恢复为所选文档的状态！", "系统消息");
             }
             else
             {
                 MessageBox.Show("恭喜，你已经成功备份当前数据！", "系统消息");
             }
         }
         catch (SqlException sexc)
         {
             MessageBox.Show("失败，可能是对数据库操作失败，原因：" + sexc, "数据库错误消息");
         }
         catch (Exception ex)
         {
             MessageBox.Show("对不起，操作失败，可能原因：" + ex, "系统消息");
         }
         finally
         {
             cmdBakRst.Dispose();
             conn.Close();
             conn.Dispose();
         }
     }

备份文件保存在数据库服务器上