我想通过PB写个数据库恢复工具,不想用SQL advantage,但在程序执行时,当执行到这一句:"load database databasename from 'e:\back\databasename.dup'"
时提示:"LOAD DATABASE command not allowed within multi-statement transaction.",(在数据库master中执行,登录用户是sa),请问各位高手有什么解决的方法,谢谢!!
...全文
314打赏收藏
PB中数据库恢复问题!
我想通过PB写个数据库恢复工具,不想用SQL advantage,但在程序执行时,当执行到这一句:"load database databasename from 'e:\back\databasename.dup'" 时提示:"LOAD DATABASE command not allowed within multi-statement transaction.",(在数据库master中执行,登录用户是sa),请问各位高手有什么解决的方法,谢谢!!
试了以后上面的提示没了,但又出现下面的提示:"Backup Server session id is: 15. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server."