备份: backup database dbname to disk='c:/dbname .bak' with password='12345'恢复: use master restore database dbname from disk='c:/dbname .bak' -- 错误 restore database dbname from disk='c:/dbname .bak' with password='12345788' -- 错误 restore database dbname from disk='c:/dbname .bak' with password='12345' -- 正确
backup database dbname to disk=filename with password=password
不用写SQL的方法可以加密吗?
备份时的命令: BACKUP DATABASE [HR_KT] TO [HR_KT] WITH INIT , NOUNLOAD , NAME = N'HR_KT 备份', NOSKIP , STATS = 10, NOFORMAT, PASSWORD ='1234'还原时的命令: RESTORE DATABASE HR_KT FROM DISK='C:\TEMP\HR_KT.BAT' WITH PASSWORD = '1234' 错误:'WITHPASSWORK'附近有语法错误还原失败,另外,我不知道在哪里打还原命令,我是在企业管理器浏览表数据的时候,按SQL按钮,在那里输入了还原命令,应该也可以的吧?但为什么不成功?
backup database dbname to disk='c:/dbname .bak' with password='12345'恢复:
use master
restore database dbname from disk='c:/dbname .bak' -- 错误
restore database dbname from disk='c:/dbname .bak' with password='12345788' -- 错误
restore database dbname from disk='c:/dbname .bak' with password='12345' -- 正确
BACKUP DATABASE [HR_KT] TO [HR_KT] WITH INIT , NOUNLOAD , NAME = N'HR_KT 备份', NOSKIP , STATS = 10, NOFORMAT, PASSWORD ='1234'还原时的命令:
RESTORE DATABASE HR_KT FROM DISK='C:\TEMP\HR_KT.BAT' WITH PASSWORD = '1234'
错误:'WITHPASSWORK'附近有语法错误还原失败,另外,我不知道在哪里打还原命令,我是在企业管理器浏览表数据的时候,按SQL按钮,在那里输入了还原命令,应该也可以的吧?但为什么不成功?
你可以通过添加job来实现SQL语句备份,用楼上的方法.