用Asp備份與恢復(fù)SQL Server 數(shù)據(jù)庫(kù)
51windows（原作）
一個(gè)用asp備份與恢復(fù)SQL Server數(shù)據(jù)庫(kù)的例子代碼，希望對(duì)一些朋友有用。(注意：數(shù)據(jù)庫(kù)使用中可能無(wú)法恢復(fù))
<HTML><HEAD><TITLE>SQL Server 數(shù)據(jù)庫(kù)的備份與恢復(fù)</TITLE><meta http-equiv='Content-Type' content='text/html; charset=gb2312'></HEAD><BODY><form method='post' name=myform>選擇操作：<INPUT TYPE='radio' NAME='act' value='backup'><label for=act_backup>備份</label> <INPUT TYPE='radio' NAME='act' value='restore'><label for=act_restore>恢復(fù)</label><br>數(shù)據(jù)庫(kù)名：<INPUT TYPE='text' NAME='databasename' value='<%=request('databasename')%>'><br>文件路徑：<INPUT TYPE='text' NAME='bak_file' value='c:$1.bak'>(備份或恢復(fù)的文件路徑)<br><input type='submit' value='確定'></form><%'SQL Server 數(shù)據(jù)庫(kù)的備份與恢復(fù)!'海娃'http://www.51windows.Netdim sqlserver,sqlname,sqlpass<a target='_blank' class='ReplaceKeyword'>word</a>,sqlLoginTimeout,databasename,bak_file,actsqlserver = 'localhost' 'sql服務(wù)器sqlname = 'sa' '用戶(hù)名sqlpassword = 'sa' '密碼sqlLoginTimeout = 15 '登陸超時(shí)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&'<font color=red><br>' response.write err.description&'</font>' end if Response.write '<font color=green>備份成功!</font>' elseif act = 'restore' then '恢復(fù)時(shí)要在沒(méi)有使用數(shù)據(jù)庫(kù)時(shí)進(jìn)行！ 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 'Force restore over existing database if err.number>0 then response.write err.number&'<font color=red><br>' response.write err.description&'</font>' end if rest.SQLRestore srv Response.write '<font color=green>恢復(fù)成功!</font>' else Response.write '<font color=red>沒(méi)有選擇操作</font>' end ifend if%></BODY></HTML>
相關(guān)文章：
1. SQLserver中的any和all運(yùn)算符的用法2. ACCESS的參數(shù)化查詢(xún),附VBSCRIPT(ASP)和C#(ASP.NET)函數(shù)第1/2頁(yè)3. SQLServer數(shù)據(jù)庫(kù)密碼短時(shí)間強(qiáng)制過(guò)期的解決4. SQLServer 表的索引碎片查詢(xún)和處理5. SQLServer常見(jiàn)數(shù)學(xué)函數(shù)梳理總結(jié)6. sqlserver給表添加新字段、給表和字段添加備注、更新備注及查詢(xún)備注(sql語(yǔ)句)7. sqlserver數(shù)據(jù)庫(kù)導(dǎo)入方法的詳細(xì)圖文教程8. SQLServer導(dǎo)出數(shù)據(jù)庫(kù)字典的詳細(xì)圖文教程9. SQLServer 清理日志的實(shí)現(xiàn)10. SQLServer數(shù)據(jù)庫(kù)誤操作恢復(fù)的方法
網(wǎng)公網(wǎng)安備