asp实现sql的备份与恢复

老林 · 2005-11-18

1、备份

<%
SQL="backup database 数据库名 to disk='"&Server.MapPath("backup")&"\"&"backuptext.dat"&"'"
set cnn=Server.createobject("adodb.connection")
cnn.open "driver={SQL Server};Server=服务器名;uid=sa;pwd="
cnn.execute SQL
on error resume next
if err<>0 then
response.write "错误："&err.Descripting
else
response.write "数据备份成功！"
end if
%>
点击展开...

2、恢复

<%
SQL="Restore database 数据库名 from disk='"&Server.MapPath("backup")&"\"&"backuptext.dat"&"'"
set cnn=Server.createobject("adodb.connection")
cnn.open "driver={SQL Server};Server=服务器名;uid=sa;pwd="
cnn.execute SQL
on error resume next
if err<>0 then
response.write "错误："&err.Descripting
else
response.write "数据恢复成功！"
end if
%>
点击展开...

kamsang · 2005-11-18

你也厉害!

落伍 · 2005-11-23

先备份。。备份好后。。。

再删数部份信息。。就反原不了了。说SQL数据库正在使用。。。。

落伍 · 2005-11-23

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]因为数据库正在使用，所以未能获得对数据库的排它访问权。

论坛

asp实现sql的备份与恢复

老林 New Member

kamsang New Member

落伍 New Member

落伍 New Member

快捷检索

asp实现sql的备份与恢复

老林 New Member

kamsang New Member

落伍 New Member

落伍 New Member