请大家帮忙想想,我想:这个问题是肯定要面对的,现在asp+SQL Server开发那么流行,数据安全性不能不考虑,这是一个不容忽视的问题。
这是我现在用的备份方案:
1、
sql = "backup database CallCenter to disk='backuptext111.dat'"
sql = "RESTORE database CallCenter from disk='backuptext111.dat'"
set cnn=server.CreateObject ("adodb.connection")
cnn.Open "provider=sqloledb.1;data source=zsh;Uid=sa;Pwd="
cnn.Execute sql
2、备份数据库,并创建数据库的复本
BACKUP DATABASE CallCenter
TO DISK = 'c:\CallCenter.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\CallCenter.bak'
RESTORE DATABASE TestDB1
FROM DISK = 'c:\CallCenter.bak'
WITH MOVE 'CallCenter_Data' TO 'c:\test\CallCenter_Data.mdf',
MOVE 'CallCenter_log' TO 'c:\test\CallCenter_log.ldf'
to :liuqinyi(宝贝)
是不是sql server 2k的数据库副本?
代码是:
BACKUP DATABASE CallCenter
TO DISK = 'c:\CallCenter.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\CallCenter.bak'
RESTORE DATABASE TestDB1
FROM DISK = 'c:\CallCenter.bak'
WITH MOVE 'CallCenter_Data' TO 'c:\test\CallCenter_Data.mdf',
MOVE 'CallCenter_log' TO 'c:\test\CallCenter_log.ldf'