| Jeff Lynch 2004-08-27, 6:06 pm |
| 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
|