Clean up your BizTalk databases

Here are a few scripts / stored procedures that most of the Biztalk newbies would love to know.

These scripts are very useful in a development environment to clean up your MessageBox and Tracking databases.

To clean up the MessageBox

  • First create the stored procedure bts_CleanupMsgBox by running the sql script found in <BizTalk Installation Folder>\Schema\msgbox_cleanup_logic.sql against your MessageBox database(BizTalkMsgBoxDb).
    • Note that your BizTalkMsgBoxDb database will already have a dummy stored procedure by the same name which does nothing, so it is important that you run the above script if this is your first time.
  • Stop all Biztalk services.
  • Reset IIS server (run iisreset from start/run) if you are running any webservices
  • Execute stored procedure bts_CleanupMsgbox on your message box database
  • Execute stored procedure bts_PurgeSubscriptions on your message box database
  • Restart all Biztalk services

To clean up the Tracking data

  • Stop all Biztalk services.
  • Execute stored procedure dtasp_CleanHMData on your tracking database (BizTalkDTADb)
  • Restart all Biztalk services

Regards

Benny Mathew Seamless Integration Solutions Biztalk Consulting, Development, Training Bangalore, India

Website: http://www.seamless.in/ Blog: http://GeeksWithBlogs.net/benny Biztalk Usergroup: http://groups.google.co.in/group/b-bug

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏CreateAMind

代码:Learning by Playing –Solving Sparse Reward Tasks from Scratch

1741
来自专栏数据结构与算法

BZOJ1046: [HAOI2007]上升序列(LIS)

  对于一个给定的S={a1,a2,a3,…,an},若有P={ax1,ax2,ax3,…,axm},满足(x1 < x2 < … < xm)且( ax1 < ...

973
来自专栏Pulsar-V

OpenCV编译参数一览

全部参数一览 //Path to a program. ANT_EXECUTABLE:FILEPATH=D:/apache-ant-1.10.1/bin/ant...

8416
来自专栏CreateAMind

一个很牛的GAN工具项目:HyperGAN

A versatile GAN(generative adversarial network) implementation focused on scalab...

1681
来自专栏杨熹的专栏

Kaggle winner 方案简介 | Understanding the Amazon from Space: 1st place

Below is a brief introduction of the 1st place winner solution to the competitio...

3998
来自专栏c#开发者

Clean up your BizTalk databases

Here are a few scripts / stored procedures that most of the BizTalk newbies woul...

3506
来自专栏耕耘实录

国外程序员推荐的免费编程书籍资源

我正试着搜集整理一个可在网上免费阅读的计算机编程书籍列表。这些书可以是某种特定编程语言,也可以计算机方面通用书籍。网上有哪些免费可用的书籍呢?

4034
来自专栏张善友的专栏

Line Counter - Writing a Visual Studio 2005 Add-In

Download original source files - 553 Kb Download new source files - 1483 Kb Do...

2128
来自专栏智能计算时代

docs and demos of Watson services

Services 1)Language 1.1) AlchemyLanguage :Demo Document AlchemyLanguage is a c...

2736
来自专栏数据结构与算法

BZOJ3288: Mato矩阵(欧拉函数 高斯消元)

Mato同学最近正在研究一种矩阵,这种矩阵有n行n列第i行第j列的数为gcd(i,j)。

993

扫码关注云+社区

领取腾讯云代金券