August 27, 2009 at 12:13 pm
Hi,
We have SQL Server 2005 and has 3 instances for serving BizTalk Apllication, INS1, INS2 and INS3
INS1 has BizTalkMsgBoxDb database
INS2 has BizTalkDTADb database
INS3 has BizTalkMgmtDb and SSODB databases
I went thorugh BOL http://msdn.microsoft.com/en-us/library/cc296856%28BTS.10%29.aspx. I understood that if we using the BizTalk Application builtin backup job Backup BizTalk Server (BizTalkMgmtDb) then only we can use BizTalk Server Log Shipping.
But out of the 3 instances, only INS2 has the builtin backup job Backup BizTalk Server (BizTalkMgmtDb). So I can use this job to backup BizTalkDTADb database, which is in INS2. But,how can we use the Built in Backup job to backup to backup the databases in INS1 & INS3 and configure BizTalk Log Shipping?
Right now I'm using my regular backup script to backup the databases in all 3 instances. But MS recommeds to use BizTalk Log shipping instaed of SQL Server Log shipping?
Anybody implemented BizTalk Log shipping in SQL Server 2005, please advice me
Thanks
August 27, 2009 at 10:25 pm
Could you please advice me on how to implement BizTalk Logshipping. I'm trying to find microsoft e-learning videos or any other videos which explains BizTalk Built in Backup Job & BizTalk built in Log shipping
thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply