Whitepaper

BizTalk Server DB: Disaster Recovery, troubleshooting & best practices

Microsoft BizTalk Server databases and the health of the databases are very important for a successful BizTalk Server messaging environment. BizTalk Server is an extremely database-intensive platform, persisting data to disk with high frequency, and one of the main reasons for that is because one of the primary design goals of BizTalk Server is to ensure that no messages are lost. Therefore, database performance is paramount to the overall performance of any BizTalk Server solution. This paper will provide you with some important aspects to consider when working with BizTalk Server databases. This whitepaper will discuss on the following aspects of Microsoft BizTalk Server databases:

  • Size of databases and tables: performance degrades on High Size of BizTalk databases
  • Important considerations to avoid large BizTalk Databases
  • Separation of data files and log files (SQL Server disk I/O contention)
  • Important considerations for BizTalk and SQL Settings
  • Available tools for monitoring and troubleshooting
  • Recovering from disasters situations (Clean up your BizTalk databases)

BizTalk Server DB: Disaster Recovery, troubleshooting & best practices
About the author(s)
Sandro Pereira

Sandro Pereira

MICROSOFT INTEGRATION MVP

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book: “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Reviewers

Steef-Jan Wiggers
Steef-Jan Wiggers

Steef-Jan Wiggers has over 15 years’ experience as a technical lead developer, application architect and consultant, specializing in custom applications, enterprise application integration (BizTalk), Web services and Windows Azure. Steef-Jan is very active in the BizTalk community as a blogger, Wiki author/editor, forum moderator, writer and public speaker in the Netherlands and Europe. For these efforts, Microsoft has recognized him a Microsoft MVP for the past 5 years.

Nino Crudele
Nino Crudele

Nino Crudele has been awarded as MVP for 9 years. Nino worked with the integration platform since 2004 and his passion is to architect and deliver significant business integration projects that provide exceptional outcomes for the client. External trading partner integration is still huge and he has delivered world class BizTalk Server solutions using and integrating many different technologies as EDI, RosettaNet, HL7, RFID, SWIFT. Besides that, he is also a Virtual Technology Specialist for BizTalk Server, a role in which he works closely with Microsoft Italy. He enjoys this role as it enables him to work with many different clients, seeing BizTalk in different scenarios from a technical point of view, size, and criticality.

Kent Weare
Kent Weare

Kent has been employed in the Energy sector in Calgary, Alberta, Canada for the past nine years. He is very passionate about Architecture especially if it involves integrating different systems. Outside his core work responsibilities, you will see him actively participating in technology communities. He recently co-authored three BizTalk books and may be found speaking at Technology events in Canada, the United States and in Europe. He has been recognized for these efforts by Microsoft as a Most Valuable Professional (MVP) for the past 8 consecutive years.

Mikael Hakansson
Mikael Hakansson

Mikael works as a solutions architect and integration specialist. In Microsoft certification terms, Mikael is an MCP, MCAD, MCSD, MCTS and MCPD. His commitment to the community has earned him the Microsoft Most Valuable Professional Award, and he is also part of the Microsoft Technical Advisor Program, working closely with the BizTalk and Azure product teams for future releases of BizTalk and related products. He is also committed to training and various speaking engagements for products and techniques such as BizTalk, SQL, Azure and Application life cycle management.

Salvatore Pellitteri
Salvatore Pellitteri

Salvatore Pellitteri lives near Milan in Italy and he is a Developer Team Manager at Microsys Srl. He works on integration application projects using BizTalk Server, since the first version of the product, working in many big integration projects with several Italian enterprise organizations using many technologies like SAP, Oracle, SQL Server, AS400, J.D. Edwards, Microsoft Dynamics and HL7. He also works on business intelligence projects using SQL Server platform.

please wait ...

Back to Top