51windows(原作)
一个用asp备份与恢复SQL Server数据库的例子代码,希望对一些朋友有用。(注意:数据库使用中可能无法恢复)
SQL Server 数据库的备份与恢复 选择操作:备份 恢复 数据库名:"> 文件路径:(备份或恢复的文件路径) <% 'SQL Server 数据库的备份与恢复! '海娃 'http://ww***windows.Net dim sqlserver,sqlname,sqlpassword,sqlLoginTimeout,databasename,bak_file,act sqlserver = "localhost" 'sql服务器 sqlname = "sa" '用户名 sqlpassword = "sa" '密码 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 re***nse.write "input database name" else if act = "backup" then Set sr***erver.CreateObject("SQ***O.SQLServer") sr***oginTimeout = sqlLoginTimeout sr***onnect sqlserver,sqlname, sqlpassword Set bak = Se***r.CreateObject("SQ***O.Backup") ba***atabase=databasename ba***evices=Files ba***iles=bak_file ba***QLBackup srv if er***umber>0 then re***nse.write er***umber&"" re***nse.write er***escription&"" end if Re***nse.write "备份成功!" elseif act = "restore" then '恢复时要在没有使用数据库时进行! Set sr***erver.CreateObject("SQ***O.SQLServer") sr***oginTimeout = sqlLoginTimeout sr***onnect sqlserver,sqlname, sqlpassword Set rest=Se***r.CreateObject("SQ***O.Restore") re***Action=0 ' full db restore re***Database=databasename re***Devices=Files re***Files=bak_file re***ReplaceDatabase=True 'Force restore over existing database if er***umber>0 then re***nse.write er***umber&"" re***nse.write er***escription&"" end if re***SQLRestore srv Re***nse.write "恢复成功!" else Re***nse.write "没有选择操作" end if end if %>
上一篇: 用asp实现的代码批量修改程序
下一篇: ASP应用:用stream读文件