Microsoft OLE DB Provider for SQL Server 错误 '80040e14' 无法打开备份设备 'd:\freehost\tianhai\web\KS_Data\SQL(2010-12-7).bak'。设备出现错误或设备脱机。详细信息请参阅 SQL Server 错误日志。 /admin/KS.Database.asp,行 133 这是找到133行代码向下内容。
conn.execute "backup database " & DataBaseName &" to disk='"& Server.MapPath(bkdbname) &"'"
on error resume next
If err Then
.echo ("<font color=red>操作失败!</font>")
Else
.echo "<div align=center><font color=green>系统主数据库备份成功!</font></div><div align=center>备份的主数据库为:" & Bkdbname & "</div>"
End If
.echo "<script>$(parent.frames['FrameTop'].document).find('#ajaxmsg').toggle(false);</script>"
End If
elseif request("Flag")="Backup1" then
CurrPath=request.form("Dbpath")
TempArr=replace(CurrPath,"/","\")
TempArr=split(TempArr,"\")
BackPath=Replace(CurrPath,TempArr(Ubound(TempArr)),"")
bkdbname=request.form("bkdbname")
if KS.backupdata(CurrPath,BackPath & bkdbname)=true then
conn.execute "backup database " & DataBaseName &" to disk='"& Server.MapPath(bkdbname) &"'"
on error resume next
If err Then
.echo ("<font color=red>操作失败!</font>")
Else
.echo "<div align=center><font color=green>系统主数据库备份成功!</font></div><div align=center>备份的主数据库为:" & Bkdbname & "</div>"
End If
.echo "<script>$(parent.frames['FrameTop'].document).find('#ajaxmsg').toggle(false);</script>"
End If
elseif request("Flag")="Backup1" then
CurrPath=request.form("Dbpath")
TempArr=replace(CurrPath,"/","\")
TempArr=split(TempArr,"\")
BackPath=Replace(CurrPath,TempArr(Ubound(TempArr)),"")
bkdbname=request.form("bkdbname")
if KS.backupdata(CurrPath,BackPath & bkdbname)=true then
所以有多种可能
1 磁盘d空间不够
2 如果你是用备份多个备份到同一个文件里,确认SQL(2010-12-7).bak文件所在的磁盘文件格式为ntfs,如果是fat32注意不要超过4g,如果是ntfs还要确认启动文件有些权限(实在不清楚就打开everyone的write)
3 d盘坏了
4 ...
不存在这个路径.
d:\freehost\tianhai\web\KS_Data
这个路径,是SQL Server上的路径喔,请做确认.
不是当前执行ASP的Web Server的.