ASP implementiert SQL Backup und Wiederherstellung

1. Backup

<%

SQL = "Backupdatabase -Datenbankname Todisk = '" & server.mappath ("backup") & "//" & "backUpptext.dat" & "'" "

setCnn = server.createObject ("adodb.Connection")

cnn.open "treiber = {sqlserver}; Server = Servername; uid = sa; pwd ="

cnn.executesql

onErrorresumeNext

ISTERR <> 0Then

Antwort.Write "Fehler:" & err.descripting

anders

Antwort.Write "Datensicherung war erfolgreich!"

Endif

%> Green Chinaipower.comayrcj6b

2. Erholung

<%

Sql = "restauredatabase -Datenbankname fromdisk = '" & server.mappath ("backup") & "//" & "backUpptext.dat" & "'" "

setCnn = server.createObject ("adodb.Connection")

cnn.open "treiber = {sqlserver}; Server = Servername; uid = sa; pwd ="

cnn.executesql

onErrorresumeNext

ISTERR <> 0Then

Antwort.Write "Fehler:" & err.descripting

anders

Antwort.Write "Datenwiederherstellung erfolgreich!"

Endif

%>