本文介绍了备份BizTalk Server(BizTalkMgmtDb)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
以下是我对备份BizTalk Server(BizTalkMgmtDb)作业的配置
设置压缩选项:exec [dbo]。[sp_SetBackupCompression] @bCompression = 1
BackupFull:exec [dbo]。[sp_BackupAllFull_Schedule]'d','BTS','D:\ BTS_SQL_Backup','0','15'
MarkAndBackUpLog:exec [dbo] 。[sp_MarkAll]'BTS','D:\ BTS_MarkAndBackupLog'
$
清除备份历史记录:exec [dbo]。[sp_DeleteBackupHistory] @ DaysToKeep = 14,@ UseLocalTime = 1
以下是我收到的错误
错误:无法打开备份设备'D:\ BTS_MarkAndBackupLog'
请注明。
解决方案
Below is the configuration I have for Backup BizTalk Server (BizTalkMgmtDb) job
Set Compression Option :exec [dbo].[sp_SetBackupCompression] @bCompression = 1BackupFull : exec [dbo].[sp_BackupAllFull_Schedule] 'd' ,'BTS','D:\BTS_SQL_Backup','0','15'
MarkAndBackUpLog : exec [dbo].[sp_MarkAll] 'BTS' , 'D:\BTS_MarkAndBackupLog'
Clear Backup History : exec [dbo].[sp_DeleteBackupHistory] @DaysToKeep=14, @UseLocalTime =1
Below is the error I got
Error: cannot Open backup device 'D:\BTS_MarkAndBackupLog'
Please advise.
解决方案
这篇关于备份BizTalk Server(BizTalkMgmtDb)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!