BTARN databases - archive/purge process? RRS feed

  • Question

  • The various tables for BTARN have grown over time.  The operations guide for maintaining the BTARN databases only addresses a subset of the tables. 

    What is the recommended way to purge the following tables?

      • BTARNARCHIVE.MessageContent - no date fields that can be used to purge data.
      • BTARNDATA.MessagesToLOB - not mentioned in the operations guide to maintain BTARN databases
      • BTARNDATA.MessagesFromLOB - not mentioned in the operations guide to maintain BTARN databases

    • Moved by Leonid Ganeline Friday, January 11, 2013 6:14 PM adapter question
    Wednesday, September 19, 2012 9:10 PM

All replies

  • Refer to the the Microsoft BizTalk 2009 Accelerator for RosettaNet Installation Guide and Help that can be downloaded from this link:

    Select RosettaNet_Main.exe - the Help provides conceptual and how to information for the BizTalk 2009 Accelerator for RosettaNet.

    Go to section

    Microsoft BizTalk Accelerator for RosettaNet Help > Operations > Maintaining BTARN Databases > Maintaining the Non-Repudiation Database Tables

    It does contains information on how to purge the MessageStorageIn and MessageStorageOut table.

    Please mark the post answered your question as answer, and mark other helpful posts as helpful, it'll help other users who are visiting your thread for the similar problem, Regards -Rohit Sharma (

    • Marked as answer by Lloyd ZhangModerator Thursday, September 27, 2012 9:00 AM
    • Unmarked as answer by OraBiz Monday, October 15, 2012 9:17 PM
    Thursday, September 20, 2012 4:45 AM
  • Thanks Rohit - I had previously looked at the document you mentioned - however the documentation is silent on the tables I am interested in purging.  MessageStorageIn and MessageStorageOut are not the same as MessagesToLOB and MessagesFromLOB.  These are completely different tables in different databases.  

    Monday, October 15, 2012 9:21 PM