远程备份MSSQL数据库的程序

选择操作：

备份　

恢复

数据库名：

备份路径：

<%
rem author:Ralf
rem QQ:183383507
rem createdtime:2007-4-28
'创建实例所要用到的一些常量,请自行修改以下三个参数：MSSQL服务器名称（sqlserver)、登录名(sqlname)、登录密码(sqlpassword)
const sqlserver="localhost",sqlname="xxxx",sqlpassword="xxxxx"

'创建变量
dim sqlLoginTimeout,databasename,bak_file,act
sqlLoginTimeout = 15
databasename = trim(request("databasename"))
bak_file = trim(request("bak_file"))
bak_file = replace(bak_file,"$1",databasename)
act = lcase(request("act"))
if databasename = "" then
response.write "input database name"
else
if act = "backup" then
Set srv=Server.CreateObject("SQLDMO.SQLServer")
srv.LoginTimeout = sqlLoginTimeout
srv.Connect sqlserver,sqlname, sqlpassword
Set bak = Server.CreateObject("SQLDMO.Backup")
bak.Database=databasename
bak.Devices=Files
bak.Files=bak_file
bak.SQLBackup srv
if err.number>0 then
response.write err.number&”
”
response.write err.description&””
end if
Response.write “备份成功!”
elseif act = “restore” then
'恢复时要在没有使用数据库时进行！
Set srv=Server.CreateObject(”SQLDMO.SQLServer”)
srv.LoginTimeout = sqlLoginTimeout
srv.Connect sqlserver,sqlname, sqlpassword
Set rest=Server.CreateObject(”SQLDMO.Restore”)
rest.Action=0 ' full db restore
rest.Database=databasename
rest.Devices=Files
rest.Files=bak_file
rest.ReplaceDatabase=True '强制还原已存在的数据库
if err.number>0 then
response.write err.number&”
”
response.write err.description&””
end if
rest.SQLRestore srv

Response.write “恢复成功!”
else
Response.write “没有选择操作”
end if
end if
%>