There are a couple dbs from BizTalk that have H U G E log
files - like 22 & 37GB
logspace (MB)
InterchangeDTA       37286.805
InterchangeSQ         22867.367

Any Idea what we should do?
Joe

[ Post a follow-up to this message ]

The easiest way is to set the SQL recovery model from "Full" to "Simple" and
set "Auto Shrink" using the SQL Enterprise Manager. Then create a Database
Maintenance Plan to backup the databases. This will set a checkpoint on the
log file and then truncate it and shrink it. The SQL Books Online is the
best place to start for further information.

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"Joe Barton" <anonymous@discussions.microsoft.com> wrote in message
news:026101c48aec$81329fb0$a601280a@phx.gbl...
> There are a couple dbs from BizTalk that have H U G E log
> files - like 22 & 37GB
>              logspace (MB)
> InterchangeDTA       37286.805
> InterchangeSQ         22867.367
>
> Any Idea what we should do?
> Joe

[ Post a follow-up to this message ]