Post reply

Does BizTalk application needs 3 sql server 2005instances??

  • June 12, 2009 at 6:08 pm

    #205953

    Hi,

    For Biztalk application, we have 3 instances in SQL Sevrer 2005

    1. ServerName\ins1

    2. Servername\ins2

    3. Servername\ins3

    ServerName\ins1 has only database called BizTalkMsgBoxDb

    ServerName\ins2 has only database called BizTalkDTADb

    ServerName\ins3 has only 2 database called BizTalkDTADb BizTalkMgmtDb and SSODB

    My questions are:

    1. I did not understand why BizTalk application needs 3 instances---Is this a must requirement

    2. Is all databases can go into single instance?

    3. Considering Biztalk application which method is preferred. Having 3 instances or single instance?

    Please suggest me..

    Thanks

  • June 12, 2009 at 6:49 pm

    #1008962

    Hello,

    It is not essential to install the BizTalk DBs on different Instances, but this is (often) done to improve scalability, performance and/or availability.

    May be take a look at this MSDN article:-

    http://msdn.microsoft.com/en-us/library/cc296593.aspx

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply