关于MS SQL数据库备份的问题。
string ls_sql
ls_sql='COMMIT TRANSACTION'
EXECUTE IMMEDIATE :ls_sql;
ls_sql="restore database nbhh from nbhh_backup_1 with recovery,stats=5"
execute immediate :ls_sql;
执行时出现以下错误:
DATABASE IN USE ,THE SYSTEM ADMINISTRATOR MUST HAVE EXCLUSIVE USE OF THE DATABASE TO RUN THE RESTORE OPERATION
就是怎么在恢复数据库时锁定数据库,