locked
biztalk database RRS feed

  • Question

  • how many database does biztalk have?


    Christiane

    Friday, September 19, 2014 3:20 AM

Answers

  • Standard BizTalk Databases:

    • BizTalkMgmtDb
    • BizTalkMsgBoxDb
    • BizTalkDTADb
    • SSODB
    • BizTalkRuleEngineDb

    When BAM installed:

    • BAMAnalysis
    • BAMArchive
    • BAMAlertsApplication
    • BAMAlertsNSMain
    • BAMPrimaryImport
    • BAMStarSchema

    For Analysis, if SQL reporting server is configured:

    • ReportServer
    • ReportServerTempDB

    If ESB Toolkit installed:

    • ESBItinerary
    • ESBAdmin
    • EsbExceptionDb

     


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.

    Friday, September 19, 2014 9:06 AM
  • Hi,

    Please find below msdn link to learn about all the BizTalk databases.

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

    Rachit

    Friday, September 19, 2014 3:41 AM
    Moderator
  • Hi Christiane,

    BizTalk Server Management database, MessageBox databases, Tracking database, and SSO database are four database which are used by BizTalk server runtime operations( thus this databases are mandatory to be there) and then if you are using Rule Engine and BAM then following Database are also used: BizTalkRuleEngine , BAMArchive,BAMPrimaryImport,BAMStarSchema.

    You can check it via SQL Server Management Studio, login to Database Engine and click on databases, you will see as shown in below snap:

    BizTalk Developer Interview Questions and Answers - BizTalk Database

    _________________________________________________

    Maheshkumar S Tiwari|User Page|Blog|BizTalk Server : How Map Works on Port Level

    Friday, September 19, 2014 4:52 AM
  • Hi,

    Here below are the default databases created for BizTalk on SQL server management studio.

    Friday, September 19, 2014 4:58 AM
  • If you want to learn more about BizTalk databases and how to keep them healthy, Please have a look of following technet wiki article

    BizTalk Databases: Survival Guide

    and

    Databases in BizTalk Server

    You will find lot of information in this. Hope this helps


    Greetings,HTH
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com

    • Marked as answer by Christiane0696 Friday, September 19, 2014 3:03 PM
    Friday, September 19, 2014 10:23 AM
    Moderator
  • Actually, it depends.

    Different features have different databases and a BizTalk App may bring additional databases as well.

    So, the only way to definitively answer this question is for you to connect to your SQL Server(s) and count.

    • Marked as answer by Christiane0696 Friday, September 19, 2014 3:04 PM
    Friday, September 19, 2014 11:15 AM
    Moderator

All replies

  • Hi,

    Please find below msdn link to learn about all the BizTalk databases.

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

    Rachit

    Friday, September 19, 2014 3:41 AM
    Moderator
  • Hi Christiane,

    BizTalk Server Management database, MessageBox databases, Tracking database, and SSO database are four database which are used by BizTalk server runtime operations( thus this databases are mandatory to be there) and then if you are using Rule Engine and BAM then following Database are also used: BizTalkRuleEngine , BAMArchive,BAMPrimaryImport,BAMStarSchema.

    You can check it via SQL Server Management Studio, login to Database Engine and click on databases, you will see as shown in below snap:

    BizTalk Developer Interview Questions and Answers - BizTalk Database

    _________________________________________________

    Maheshkumar S Tiwari|User Page|Blog|BizTalk Server : How Map Works on Port Level

    Friday, September 19, 2014 4:52 AM
  • Hi,

    Here below are the default databases created for BizTalk on SQL server management studio.

    Friday, September 19, 2014 4:58 AM
  • Standard BizTalk Databases:

    • BizTalkMgmtDb
    • BizTalkMsgBoxDb
    • BizTalkDTADb
    • SSODB
    • BizTalkRuleEngineDb

    When BAM installed:

    • BAMAnalysis
    • BAMArchive
    • BAMAlertsApplication
    • BAMAlertsNSMain
    • BAMPrimaryImport
    • BAMStarSchema

    For Analysis, if SQL reporting server is configured:

    • ReportServer
    • ReportServerTempDB

    If ESB Toolkit installed:

    • ESBItinerary
    • ESBAdmin
    • EsbExceptionDb

     


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.

    Friday, September 19, 2014 9:06 AM
  • If you want to learn more about BizTalk databases and how to keep them healthy, Please have a look of following technet wiki article

    BizTalk Databases: Survival Guide

    and

    Databases in BizTalk Server

    You will find lot of information in this. Hope this helps


    Greetings,HTH
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com

    • Marked as answer by Christiane0696 Friday, September 19, 2014 3:03 PM
    Friday, September 19, 2014 10:23 AM
    Moderator
  • Actually, it depends.

    Different features have different databases and a BizTalk App may bring additional databases as well.

    So, the only way to definitively answer this question is for you to connect to your SQL Server(s) and count.

    • Marked as answer by Christiane0696 Friday, September 19, 2014 3:04 PM
    Friday, September 19, 2014 11:15 AM
    Moderator