asp.net备份还原数据库

protected void Button1_Click(object sender, EventArgs e){string SqlStr1 = @\"server=SUN-54A9D63F550\\SQL2005;database=wuye;Uid=sa;Pwd=123456\";string SqlStr2 = @\"backup database wuye to disk=\'D:\\TempDB\\wuye1.bak\'\";SqlConnection con = new SqlConnection(SqlStr1);con.Open();try{SqlCommand com = new SqlCommand(SqlStr2, con);com.ExecuteNonQuery();Response.Write(\" \");}catch (Exception error){Response.Write(error.Message);Response.Write(\" \");}finally{con.Close();}}protected void Button2_Click(object sender, EventArgs e){string SqlStr1 = @\"server=SUN-54A9D63F550\\SQL2005;database=master;Uid=sa;Pwd=123456\";string SqlStr2 = @\"create database wuye1 use master restore database wuye1 from disk=\'D:\\TempDB\\wuye1.bak\' with replace\";SqlConnection con = new SqlConnection(SqlStr1);con.Open();try{SqlCommand com = new SqlCommand(SqlStr2, con);com.ExecuteNonQuery();Response.Write(\" \");}catch (Exception error){Response.Write(error.Message);Response.Write(\" \");}finally{con.Close();}}

注意：其中可能遇到的问题：

1、需要备份日志

BACKUP LOG wuye TO DISK = \’D:\\TempDB\\wuye1.bak\’ WITH NORECOVERY

2、覆盖现有数据库