ASP备份SQL Server数据库改进版 复制代码 代码如下:
<% 'SQL Server 数据库的备份与恢复! if request("action")="backupdatabase" Then dim sqlserver,sqlname,sqlpassword,sqlLoginTimeout,databasename,bak_file,act sqlserver = "localhost" sqlname = "sa" sqlpassword ="password" 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.Action = 0 bak.Initialize = 1 'bak.Replace = True bak.Files=bak_file bak.SQLBackup srv if err.number>0 then response.write err.number&"