Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

large tables in Biztalk 2004 to delete

Status
Not open for further replies.
timscronin

timscronin

MIS
Jun 27, 2001
837
0
0
US
Sorry this is coming from a DBA, trying to cleanup some of the tables in the Biztalkmsgboxdb that are very large. They are Tracking_Parts1 and Tracking_spool1. They are well over 700,000 rows and I have been told by Biztalk developers we only need last weeks worth of data. I looked at the cleanup sp's and jobs created by Biztalk but these tables are not referenced. Is there a sp I am missing, or is this a manual process?
 
Status
Not open for further replies.

Similar threads

madhavankovai
  • Locked
  • Question
BizTalk server monitoring and analytics software
Replies
0
Views
85
madhavankovai
madhavankovai
Andrew Zwickl
  • Locked
  • Question
AS2 Connection Fails to HTTPS Endpoint (How to Configure)
Replies
0
Views
105
Andrew Zwickl
Andrew Zwickl
Mithu33
  • Locked
  • Question
Dynamic Database Action in BizTalk 2006
Replies
0
Views
88
Mithu33
Mithu33
hnida
  • Locked
  • Question
Biztalk oracle adapter: how i can change the target namespace ?
Replies
0
Views
89
hnida
hnida
benvictor
  • Locked
  • Question
Time delay in Verastream Host Interface - BizTalk interface.
Replies
0
Views
85
benvictor
benvictor

Part and Inventory Search

Sponsor

Back
Top