I want to switch the recovery model of BizTalkMsgBoxDb and BizTalkDTADb to simple on a production environment. We're using a third party solution for backup strategy. for high availability i plan to deploy cluster instead of log shipping.
Simple receovery model is not recommended way. Please see extract below from http://msdn.microsoft.com/en-us/library/cc296892(BTS.10).aspx.
"The Backup BizTalk Server job is the only supported method to backup the BizTalk Server databases and requires that all of the BizTalk Server databases are configured to use the SQL Server full recovery model. "
Please mark it as answer if it helps
Which third party solution you are using for backup strategy? Also Simple recovery model is not recommended.
Any reason you are not using BizTalk Log shipping ?
MCTS BizTalk Server http://alamnaushad.wordpress.com If this answers your question please mark.
I'm using clustering A/P with third party backup solution cause log shipping require an additional sql server 2008 licence. Also clustering provide a High-Availability and automatic FAILOVER wich not the case with Log Shipping.
- Edited by Tarik Arrad Friday, December 31, 2010 10:07 AM
If SQL Instance is not being used as a production then i believe you would not need a license for that.
MCTS BizTalk Server http://alamnaushad.wordpress.com/ If this answers your question please mark.