本文介绍了备份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 = 1
BackupFull : 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)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-23 02:23