在ASP中用SQL语句备份、恢复数据库

数据库用sql server2000,在asp中,能否实现数据库的备份和数据恢复
---------------------------------------------------------------

sql="BACKUP DATABASE ["&strDatabase&"] TO DISK='"& strBackupPath &"' WITH Format, Name='All_Data'" '完全备份
sql="BACKUP DATABASE ["&strDatabase&"] TO DISK='"& strBackupPath &"' WITH DIFFERENTIAL, Name='DIF_Data'" '差异备份

详细用户可参照联机手册

Published At
Categories with Web编程
comments powered by Disqus