91网首页-91网页版-91网在线观看-91网站免费观看-91网站永久视频-91网站在线播放

[br]　　選擇操作：備份 [br]　　恢復 [br]　　
數據庫名："> [br]　　
文件路徑：(備份或恢復的文件路徑)
[br]　　 [br]　　

[br]<% [br]'sql server 數據庫的備份與恢復! [br]if request("action")="backupdatabase" then [br]dim sqlserver,sqlname,sqlpassword,sqllogintimeout,databasename,bak_file,act [br]sqlserver = "(local)"[br]sqlname = "pinbo56_f"[br]sqlpassword ="123456"[br]sqllogintimeout = 15[br]databasename = trim(request("databasename")) [br]bak_file = trim(request("bak_file")) [br]bak_file = replace(bak_file,"＄1",databasename)[br]act = lcase(request("act"))[br]if databasename = "" then[br]response.write "input database name"[br]else[br]if act = "backup" then[br]set srv=server.createobject("sqldmo.sqlserver")[br]srv.logintimeout = sqllogintimeout[br]srv.connect sqlserver,sqlname, sqlpassword[br]set bak = server.createobject("sqldmo.backup")[br]bak.database=databasename[br]bak.devices=files [br]bak.action = 0[br]bak.initialize = 1[br]'bak.replace = true[br]bak.files=bak_file [br]bak.sqlbackup srv[br]if err.number>0 then [br]response.write err.number&"
" [br]response.write err.description&"" [br]end if[br]response.write "備份成功!" [br]elseif act="restore" then[br]'恢復時要在沒有使用數據庫時進行！ [br]set srv=server.createobject("sqldmo.sqlserver")[br]srv.logintimeout = sqllogintimeout[br]srv.connect sqlserver,sqlname, sqlpassword[br]set rest=server.createobject("sqldmo.restore")[br]rest.action=0 ' full db restore [br]rest.database=databasename [br]rest.devices=files [br]rest.files=bak_file [br]rest.replacedatabase=true 'force restore over existing database [br]if err.number>0 then[br]response.write err.number&"
"[br]response.write err.description&""[br]end if[br]rest.sqlrestore srv[br]response.write "恢復成功!"[br]else [br]response.write "<font color=red>沒有選擇操作"[br]end if [br]end if [br]end if[br]%>