- This topic has 9 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
Hi
My biztalkmsgboxdb has grown to 9 Gb (datafile) and the biztalkDTAdb is 4.5 gb. This leaves just 200 mb remaining on my server disk. I want to reduce the size of the DBs.
I tried the purge_DTAdb.sql script but received the error tempdb log full (no disk space).
Is there a way to free up space taken up by these 2 dbs as the messages are rarely tracked.
thanks
-
and sqlagent is running and so are all the jobs. biztalk backup is also running. I have also scheduled a job which shrinks both these dbs but the size still increases after a little while.
-
I truncated the dta_DebugTrace table, it had 6106000 rows but there was no significant increase in disk space. the purge script fails due to shortage of space for tempdb.
Is there a way to purge messages in MsgboxDb as it is taking up much more space (9 Gb)
My understanding is that once the messages are copied into DTAdb they are purged from msgboxdb so msgboxdb should not be larger than dtadb.
-
yes the agent is running and all jobs are enabled thats what keeping the disk from going to 0 B 🙂 SP1 is not installed. will installing SP1 solve my problem ?
I am hesitant to install SP1 as it will take up some more disk space.
-
-
Must I stop the BizTal services (applications) when I run the Microsoft given purge script?
It runs since yesterday (all the jobs), but the size of the log file doesn’t decrease (it’s now 20Gb…).-
Ideally, you would use the sample purge jobs provided by Microsoft.
There’s one table you can clean-up manually: dta_DebugTrace.
This table keeps track of run time of every single expression shape in every single orchestration (forever) – until you purge.You can run this query to see how much history you have by year/month:
use BiztalkDTADB
[code:1:ec90262ef2]select datepart(year,dtTimeStamp),
datepart(month,dtTimeStamp),
count(*) as ‘rowcount’
from dta_DebugTrace
group by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp)
order by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp) [/code:1:ec90262ef2]To clean up this database, it is suggested you run the following:
[code:1:ec90262ef2]select * from dta_DebugTrace where dtTimeStamp < ‘2006-01-01′[/code:1:ec90262ef2]
Then after confirming the results, change the “select” to a “delete”.
You could try deleting a week or a month at a time, instead of all at once. -
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.