1. النسخ الاحتياطي
<٪
sql = "backupdatabase database name todisk = '" & server.mappath ("backup") و "//" & "backupuptext.dat" & "" "
setcnn = server.createObject ("adodb.connection")
cnn.open "driver = {sqlserver} ؛ server = server name ؛ uid = sa ؛ pwd ="
cnn.executesql
onerrorresumenext
iferr <> 0then
استجابة. write "خطأ:" & err.descripting
آخر
Response.write "كان النسخ الاحتياطي للبيانات ناجحًا!"
Endif
٪> Green ChinaiPower.comayrcj6b
2. الانتعاش
<٪
sql = "restoreataBase Database Name fromDisk = '" & server.mappath ("backup") و "//" & "backupuptext.dat" & "" "
setcnn = server.createObject ("adodb.connection")
cnn.open "driver = {sqlserver} ؛ server = server name ؛ uid = sa ؛ pwd ="
cnn.executesql
onerrorresumenext
iferr <> 0then
استجابة. write "خطأ:" & err.descripting
آخر
استجابة. الكتابة "استرداد البيانات نجح!"
Endif
٪>