备份BizTalk Server（BizTalkMgmtDb） [英] Backup 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'



请注明。

解决方案

您好SelvarajM，

感谢您在MSDN论坛上发帖。

我怀疑用户对此文件夹没有正确的权限。

请查看以下文章，了解分步说明。

https://docs.microsoft.com/en-us/biztalk/core/how-to-configure-the-backup-biztalk-server-job

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.

解决方案

Hi SelvarajM,

Thank you for posting on MSDN forum.

I suspect user doesn't have correct permission on this folder.

Please check below article for step by steps instructions.

https://docs.microsoft.com/en-us/biztalk/core/how-to-configure-the-backup-biztalk-server-job

这篇关于备份BizTalk Server（BizTalkMgmtDb）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！