PB中 如何进行sql数据库备份及恢复
PB中 如何进行sql数据库备份及恢复？
[解决办法]
itr_database 为连接master数据库的事物
ls_backupfilename 为备份路径。
sp_addumpdevice和sp_dropdevice 都是SQL和存储过程，楼主可参照看看
itr_database.AutoCommit = TRUE
ls_use = "EXEC sp_addumpdevice 'disk'"+" , '"+ dbname + "' , "+" '" + ls_backupfilename + "'"
EXECUTE IMMEDIATE : ls_use using itr_database ;
ls_use = 'BACKUP DATABASE '+ dbname +' to '+ dbname + ''
EXECUTE IMMEDIATE : ls_use using itr_database;
ls_use = "EXEC sp_dropdevice '" + dbname + "'"
EXECUTE IMMEDIATE : ls_use using itr_database;
itr_database.AutoCommit = FALSE
