sql sever2005数据库备份和还原（Asp.net C#）

// 备份按钮

protected void BtnBack_Click(object sender, EventArgs e)
        {
            
            string saveAway = "D:\\S2.bak";//备份文件保存位置
            string cmdText = @"use master;backup database TrainSearch to disk='" + saveAway + "'";//TrainSearch数据库名称，你要改为你自己的
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdText;
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();           
            Common.ShowMessage.Show(Page, "yes", "备份成功！");
            con.Close();
            BackUpTime bt = new BackUpTime();
            string time = DateTime.Now.ToString();
            if (bt.EditBackTime(1, time))
            {

            }
            else
            { 
            }
            
        }

//还原按钮
        protected void BtnHf_Click(object sender, EventArgs e)
        {

            string strsql_kill = "SELECT spid FROM sys.sysprocesses ,sys.sysdatabases WHERE sys.sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='TrainSearch'";
            DataSet ds = new DataSet();
            SqlCommand cmdd = new SqlCommand();            
            cmdd.Connection = con;
            cmdd.CommandText = strsql_kill;
            con.Open();
            cmdd.ExecuteNonQuery();
            SqlDataAdapter sda = new SqlDataAdapter(cmdd);
            sda.Fill(ds);

            ArrayList list = new ArrayList();
            for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
            {
                list.Add(ds.Tables[0].Rows[j][0].ToString());
            }

            for (int i = 0; i < list.Count; i++)
            {
                cmdd = new SqlCommand("KILL " + list[i].ToString(), con);
                cmdd.ExecuteNonQuery();
            }
            con.Close();



            string cmdText = @"use master;restore database TrainSearch from disk='D:\S2.bak' with REPLACE";//D:\S2.bak本分数据库源
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdText;
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            Common.ShowMessage.Show(Page, "yes", "还原成功！");
            con.Close();
        }

当然备份和还原数据库你都可以自己选择路径，我这里了方便就没加那个功能，想实现可以加一个FIleUpload控件用于浏览数据源或者备份路径