locked
BAM Archive RRS feed

  • Question

  • Hi All,

    As part of maintenance to the BAM db, we have configured a SQL job to run the BAM_DM_ <<BAM Activity Name>> packages. When we execute this, partition tables are created in the BAMPrimaryImport DB but the old data are not moved to BAMArchive db. We have configured to archive any data old than last 1 month, in our BAMPrimaryImportDb we have data for more than 6 months.


    FYI, we use BizTalk 2006 R2. Any suggestions.

     


    Wednesday, October 17, 2012 3:45 PM

Answers

  • Have you checked this blog post, This looks very similar to your issue.

    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
    My TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

    Wednesday, October 17, 2012 3:50 PM
    Moderator
  • Hi,

    The archive process will not start until the CreationTime of the row in the  bam_Metadata_Partitions  is older than the OnlineWindowTimeLength.

    Reference:http://www.biztalkbill.com/Home/tabid/40/EntryId/103/BizTalk-BAM-Archiving.aspx

    Regards,

    M.R.ASHWINPRABHU


    If this answers your question please mark it accordingly

    Wednesday, October 17, 2012 4:16 PM
  • I hope you've had a look at http://msdn.microsoft.com/en-us/library/aa560754.aspx

    That article should help you understand what the softpurge/hardpurge limits are, which jobs control what activities in regards to BAM Archiving/Purging and most certainly help you assess the root cause for the problem you're facing.

    Regards.

    Thursday, October 18, 2012 5:28 AM

All replies

  • Have you checked this blog post, This looks very similar to your issue.

    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
    My TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

    Wednesday, October 17, 2012 3:50 PM
    Moderator
  • Hi,

    The archive process will not start until the CreationTime of the row in the  bam_Metadata_Partitions  is older than the OnlineWindowTimeLength.

    Reference:http://www.biztalkbill.com/Home/tabid/40/EntryId/103/BizTalk-BAM-Archiving.aspx

    Regards,

    M.R.ASHWINPRABHU


    If this answers your question please mark it accordingly

    Wednesday, October 17, 2012 4:16 PM
  • I hope you've had a look at http://msdn.microsoft.com/en-us/library/aa560754.aspx

    That article should help you understand what the softpurge/hardpurge limits are, which jobs control what activities in regards to BAM Archiving/Purging and most certainly help you assess the root cause for the problem you're facing.

    Regards.

    Thursday, October 18, 2012 5:28 AM