Hi,

I need a script that will clear the DTADatabase based on MessageType and
fromdate-todate.
My DTADatabase is BIG!

Does anybody has this script already made?

/Daniel

[ Post a follow-up to this message ]

Hi Daniel,

There's a script included in the SDK samples (C:\Program Files\Microsoft
BizTalk Server 2004\SDK\Samples\Admin\Database Maintenance) that will
prune the tracking database tables based on date.  It won't prune by
MessageType, though.

If your tracking DB is very large, this job can take a very long time to
run.  MS has a hotfix available that will actually truncate the tables
completely rather than deleting from them.  This may be an option for
you, if you can't afford for the purge job to run for a very long time.

Here's a link to the hotfix:
http://support.microsoft.com/?id=894253

Thanks,
Craig

DW wrote:
> Hi,
>
> I need a script that will clear the DTADatabase based on MessageType and
> fromdate-todate.
> My DTADatabase is BIG!
>
> Does anybody has this script already made?
>
> /Daniel

[ Post a follow-up to this message ]

Hi,

I don't think there's a supported way of doing this.

One option may be to configure your tracking options, which will mean the
tracking DB will reduce size over time (provided you have enabled the prune
tracking DB job).


--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith



"Craig Vermeer" wrote:

> Hi Daniel,
>
> There's a script included in the SDK samples (C:\Program Files\Microsoft
> BizTalk Server 2004\SDK\Samples\Admin\Database Maintenance) that will
> prune the tracking database tables based on date.  It won't prune by
> MessageType, though.
>
> If your tracking DB is very large, this job can take a very long time to
> run.  MS has a hotfix available that will actually truncate the tables
> completely rather than deleting from them.  This may be an option for
> you, if you can't afford for the purge job to run for a very long time.
>
> Here's a link to the hotfix:
> http://support.microsoft.com/?id=894253
>
> Thanks,
> Craig
>
> DW wrote: 
>

[ Post a follow-up to this message ]