|
Home > Archive > BizTalk Server > March 2006 > SQL-script to purge BizTalkDTA
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL-script to purge BizTalkDTA
|
|
|
| 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
| |
| Craig Vermeer 2006-03-15, 5:52 pm |
| 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
| |
| Alan Smith 2006-03-27, 8:38 am |
| 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:
>
|
|
|
|
|