跟我學(xué)asp備份sql server數(shù)據(jù)庫(kù)

作者：創(chuàng)新互聯(lián) 文章來(lái)源：虛擬主機(jī)部點(diǎn)擊數(shù)：更新時(shí)間：2010-11-19
　　對(duì)于一個(gè)網(wǎng)站來(lái)說(shuō)，數(shù)據(jù)庫(kù)的重要性就好比人的胃一樣，它會(huì)儲(chǔ)存加入的數(shù)據(jù)信息，支撐我們的網(wǎng)站運(yùn)行。數(shù)據(jù)庫(kù)很重要，所以我們需要做好一些備份，以盡可能的減少網(wǎng)站被入侵時(shí)的損失。具體操作，請(qǐng)看小編的分析。
<HTML>
<HEAD>
<TITLE>數(shù)據(jù)庫(kù)操作_www.dushuwu.nhet</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<BODY>
<form method="post" name=myform>
<%if action="restore" then%><INPUT TYPE="hidden" name="action" value="restore">準(zhǔn)備恢復(fù)數(shù)據(jù)庫(kù)。。。
<%elseif action="backup" then%><INPUT TYPE="hidden" name="action" value="backup">準(zhǔn)備備份數(shù)據(jù)庫(kù)。。。<%else%>
選擇操作：
<INPUT TYPE="radio" name="action" id="act_backup" value="backup"><label for=act_backup>備份</label>
<INPUT TYPE="radio" name="action" id="act_restore" value="restore"& gt;<label for=act_restore>恢復(fù)</label><%end if%>
<br>數(shù)據(jù)庫(kù)名：<INPUT TYPE="text" name="databasename" value="50forum">
<br>文件路徑：<INPUT TYPE="text" name="bak_file" value="50forum.bak">(備份或恢復(fù)的文件路徑)<br>
<input type="submit" value="確定">
</form>
<%
’SQL Server 數(shù)據(jù)庫(kù)的備份與恢復(fù)!
’http://www.dwww.cn
dim sqlserver,sqlname,sqlpassword,sqlLoginTimeout,databasename,bak_file,act
sqlserver = "localhost" ’sql服務(wù)器
sqlname = "sa" ’用戶名
sqlpassword = "sa" ’密碼
sqlLoginTimeout = 15 ’登陸超時(shí)
databasename = trim(request("databasename"))
bak_file = trim(request("bak_file"))
bak_file = Server.MapPath("backup/"&bak_file)
act = lcase(request("action"))
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.Action = 0
bak.Initialize = 1
’bak.ReplaceDatabase = True
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>"
srv.disconnect
Set srv = nothing
Set bak = nothing
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>"
srv.disconnect
Set srv = nothing
Set rest = nothing
else
Response.write "<font color=red>沒(méi)有選擇操作</font>"
end if
end if
%>
</BODY>
</HTML>
　　如果你在網(wǎng)站制作上遇到什么難題，歡迎咨詢成都創(chuàng)新互聯(lián)網(wǎng)站建設(shè)，我們專(zhuān)業(yè)從事網(wǎng)站建設(shè)，網(wǎng)頁(yè)制作，域名注冊(cè)，虛擬主機(jī)，企業(yè)郵局，網(wǎng)站備案和服務(wù)器租用等項(xiàng)目，歡迎您的咨詢了解。您也可以登錄我們的論壇（http://bbs.cdxwcx.com）來(lái)和更多的網(wǎng)站愛(ài)好者進(jìn)行交流！
ADO 存取數(shù)據(jù)庫(kù)時(shí)是我重要屬性和方法 :上一篇
ADO 存取數(shù)據(jù)庫(kù)時(shí)如何分頁(yè)顯示 :下一篇

国产又黄又粗又长又大的视频-色婷婷久久一区二区爽爽爽-欧美日本韩国国产在线观-尹人香蕉琪琪在现观看

虛擬主機(jī)

服務(wù)器租用

企業(yè)郵箱

網(wǎng)站程序

營(yíng)銷(xiāo)推廣

網(wǎng)站建設(shè)

域名注冊(cè)

前端開(kāi)發(fā)

網(wǎng)站備案

移動(dòng)互聯(lián)網(wǎng)

跟我學(xué)asp備份sql server數(shù)據(jù)庫(kù)

跟我學(xué)asp備份sql server數(shù)據(jù)庫(kù)

數(shù)據(jù)庫(kù)相關(guān)文章