I learned something today about SQL 2008 and BizTalk's SQL agent jobs. You must leave all BizTalk databases recovery model to "Full". I encounted a database set with the recovery model that was changed to "Simple" and it caused the agent's jobs to fail.
The reason for this is that "TRUNCATE_ONLY" has been deprecated for SQL Server 2008. This flag forces you to keep the recovery model as full. When I changed it back everything began funtioning normally again.
3 weeks ago
1 comment:
Attention! Our paper writing service is here to help you with your complicated coursework term papers, essays and many other academic projects! Our specialists are familiar with all types of academic papers! It won't be a challenge!
Post a Comment