非常好用的asp备份,还原SQL数据库的代码

也想出现在这里？点击联系我~

1. <formmethod="post"name="myform"action="?action=backupdatabase">
2. 选择操作：
3. <inputtype="radio"name="act"id="act_backup"value="backup">
4. <labelfor=act_backup>备份</label>
5. <inputtype="radio"name="act"id="act_restore"value="restore">
6. <labelfor=act_restore>恢复</label>
7. <br>
8. 数据库名：
9. <inputtype="text"name="databasename"value="<%=request("databasename")%>">
10. <br>
11. 文件路径：
12. <inputtype="text"name="bak_file"value="c:\\$1.bak">
13. (备份或恢复的文件路径)<br>
14. <inputtype="submit"value="确定"id=submit1name=submit1>
15. </form>
16. <%
17. 'sqlserver数据库的备份与恢复!
18. ifrequest("action")="backupdatabase"then
19. dimsqlserver,sqlname,sqlpassword,sqllogintimeout,databasename,bak_file,act
20. '**************************************************************************
21. sqlserver="127.0.0.1"
22. sqlname="sa"
23. sqlpassword="111"
24. sqllogintimeout=15
25. databasename=trim(request("databasename"))
26. bak_file=trim(request("bak_file"))
27. bak_file=replace(bak_file,"$1",databasename)
28. act=lcase(request("act"))
29. '**************************************************************************
30. ifdatabasename=""then
31. response.write"inputdatabasename"
32. else
33. ifact="backup"then
34. setsrv=server.createobject("sqldmo.sqlserver")
35. srv.logintimeout=sqllogintimeout
36. srv.connectsqlserver,sqlname,sqlpassword
37. setbak=server.createobject("sqldmo.backup")
38. bak.database=databasename
39. bak.devices=files
40. bak.action=0
41. bak.initialize=1
42. 'bak.replace=true
43. bak.files=bak_file
44. bak.sqlbackupsrv
45. iferr.number>0then
46. response.writeerr.number&"<fontcolor=red><br>"
47. response.writeerr.description&"</font>"
48. endif
49. response.write"<fontcolor=green>备份成功!</font>"
50. endif
52. ifact="restore"then
53. '恢复时要在没有使用数据库时进行！
54. setsrv=server.createobject("sqldmo.sqlserver")
55. srv.logintimeout=sqllogintimeout
56. srv.connectsqlserver,sqlname,sqlpassword
57. setrest=server.createobject("sqldmo.restore")
58. rest.action=0'fulldbrestore
59. rest.database=databasename
60. rest.devices=files
61. rest.files=bak_file
62. rest.replacedatabase=true'forcerestoreoverexistingdatabase
63. iferr.number>0then
64. response.writeerr.number&"<fontcolor=red><br>"
65. response.writeerr.description&"</font>"
66. endif
67. rest.sqlrestoresrv
68. response.write"<fontcolor=green>恢复成功!</font>"
69. else
70. response.write"<fontcolor=red>没有选择操作</font>"
71. endif
72. endif
73. endif
74. %>