求教:pb6.5下备份sql2000数据库问题
现在要求编程对sql2000下的数据库test进行完全备份,已试过的操作:
ls_path //存放路径
ls_file//存放备份文件名(要求能动态改变)
ls_sql = "BACKUP DATABASE [test] TO DISK = N'"+ls_path+"' WITH NOINIT , NOUNLOAD , NAME = N'"+ls_file+"', NOSKIP , STATS = 10, NOFORMAT"
execute immediate :ls_sql using sqlca;
commit;
debug 模式下跟踪到execute 时报错如下:
Cannot perform a backup or restore operation within a transaction.
向诸位高手请教,在线等待中。。。。