by 清泉
13. 十月 2008 09:39
Asp数据库备份语句:backup database [数据库名] to disk="要备份到的路径",SQL的备份文件只能保存在原服务器上面,而不能备份到别的地方
<%
CONN_STR = "Server=FTWEB;User ID=sa;Password=1319707a&b1;Database=ftcms_data"
connstr="Provider=SQLOLEDB.1;Persist Security Info=false;"&CONN_STR&";
set conn=server.createobject("adodb.connection")
conn.open connstr
conn.execute("backup datebase ftcms_data to disk = G:\zbCMS\FS_Inc\NewBackup.rar")
response.write"数据库备份完成。"
%>