专栏首页c#开发者Clean up your BizTalk databases

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 条评论
登录 后参与评论

相关文章

  • Clean up your BizTalk databases

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

    阿新
  • Using ASP.NET and jQuery to Pass Multiple Values from a GridView to Another Page

    Using ASP.NET and jQuery to Pass Multiple Values from a GridView to Another Page...

    阿新
  • Beini Compatible Hardware List

    Beini Compatible Hardware List Do not expect that you will be able to hack WiFi ...

    阿新
  • hdu 3853LOOPS (概率DP)

    LOOPS Time Limit: 15000/5000 MS (Java/Others)    Memory Limit: 125536/65536 K (J...

    Gxjun
  • 杭电60题--part 1 HDU1003 Max Sum(DP 动态规划)

    Given a sequence a[1],a[2],a[3]......a[n], your job is to calculate the max sum ...

    风骨散人Chiam
  • 本质空间的张量网络的等级(CS)

    阶-d张量的层次(多线性)等级是决定将张量表示为(树)张量网络(TN)的成本的关键。一般来说,众所周知,对于一个固定的精度,一个具有随机条目的张量不能被期望在没...

    管欣8078776
  • python functools.wraps装饰器模块

    D:\Python27\python.exe D:/Python/functools_study/完整的装饰器.py 这是不带参数的装饰器,开始执行 3...

    周小董
  • Java企业微信开发_15_查询企业微信域名对应的所有ip

    shirayner
  • 盘一盘 Python 系列 11 - Keras (中)

    本文是 Python 系列的第十四篇,也是深度学习框架的 Keras 中篇,离上篇相隔时间太久。整套 Python 盘一盘系列目录如下:

    用户5753894
  • 简单几步,创建自己的域名邮箱

    andy@qq.com的邮件客户端程序(比如 Outlook Express)与 qq 的 SMTP 服务器建立网络连接,并以 andy 的用户名和密码进行登录...

    IMWeb前端团队

扫码关注云+社区

领取腾讯云代金券