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、覆盖现有数据库

use master restore database wuye from disk='D:\TempDB\wuye1.bak' with replace

在最后加上with replace就可以了。

转载于:https://www.cnblogs.com/hehuo-ping/archive/2011/02/22/1961196.html