|
Home > Archive > BizTalk Server > February 2004 > purge InterchangeDTA
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 |
purge InterchangeDTA
|
|
|
| Hello,
Our InterchangeDTA is very big 15 G, we used
dta_purge_old_records from
(BTS_Tracking_Archive_Purge_Script.sql) after that I
shrinked database file and log file and I gain only 1.5 G
that I loss in few time.
Please help me!!
thanks.
| |
| Shaheer Abubucker 2004-02-08, 8:39 am |
| Hello,
What parameters did you use when calling the dta_purge_old_records stored
proc from the job created by the sql script?
It is possible that the parameters you send in only purged 1.5GB worth of
data.
For example, to delete but not archive all completely processed
interchanges and documents that are older than one day, the parameters are
as follows:
dta_purge_old_records 1, 24, 1,0
To archive and delete all interchanges regardless of whether they are
completely processed, with the exception of the latest 1,000 interchanges,
the parameters are as follows:
dta_purge_old_records 2, 1000, 0, 1,
You can find the usage information for this stored proc at
http://msdn.microsoft.com/library/e...k_docs_rbhz.asp
Thanks,
Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
--------------------
|
| Hello,
| Our InterchangeDTA is very big 15 G, we used
| dta_purge_old_records from
| (BTS_Tracking_Archive_Purge_Script.sql) after that I
| shrinked database file and log file and I gain only 1.5 G
| that I loss in few time.
| Please help me!!
| thanks.
|
| |
| Shaheer Abubucker 2004-02-08, 8:39 am |
| Also, are you using any of the information in the DTA database?
If not, go to the BizTalk Admin console, right click on Groups, go to
Properties, and click on the Tracking tab. You can uncheck tracking so
BizTalk no longer writes to the DTA database. Make sure you do this only
if you will never need any of that data.
Thanks,
Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
--------------------
|
| Hello,
| Our InterchangeDTA is very big 15 G, we used
| dta_purge_old_records from
| (BTS_Tracking_Archive_Purge_Script.sql) after that I
| shrinked database file and log file and I gain only 1.5 G
| that I loss in few time.
| Please help me!!
| thanks.
|
|
|
|
|
|