用最简单的步骤备份sql数据库的文件到本地: response.charset = utf-8 session.codepage = 65001 response.buffer=true response.clear '根据你的情况修改用户名和密码 constr=provider=sqloledb.1;persist security info=true;user id=endiva;password=endi
用最简单的步骤备份sql数据库的文件到本地:
response.charset = utf-8
session.codepage = 65001
response.buffer=true
response.clear
'根据你的情况修改用户名和密码
constr=provider=sqloledb.1;persist security info=true;user id=endiva;password=endiva;data source=211.160.78.6
set conn=server.createobject(adodb.connection)
conn.open constr
bkfname=server.mappath(format_time(now(),5)&database.bak)
sqlstr=backup database fang to disk='+bkfname+' with init
conn.execute sqlstr
conn.close
response.write database [fang] is backup success!
response.write click download
如果想直接备份并下载，可以加上下边的这部分，就会备份后自动保存。但是弹出的文件是.asp的文件，修改下就ok。
'set fn=server.createobject(adodb.stream)
'fn.mode=3 '读写
'fn.type=1 '数据类型为：adtypebinary
'fn.open
'fn.loadfromfile bkfname '将bkfname指定的文件装入对像中
'response.contenttype=application/octet-stream
'response.binarywrite fn.read
'fn.close
，