一个用asp备份与恢复SQL Server数据库的例子代码

            response.write err.number&"<font color=red><br>"

            response.write err.description&"</font>"

        end if

        Response.write "<font color=green>备份成功!</font>"

        srv.disconnect

        Set srv = nothing

        Set bak = nothing

    elseif act = "restore" then

        '恢复时要在没有使用数据库时进行！

        Set srv=Server.CreateObject("SQLDMO.SQLServer")