I am assuming that you can connect to the database with an admin id for that
database in Enterprise Manager. There are variations of how you could have
this setup, so I will not provide details.

From Enterprise Manager, select the BEDB database and right click for
Properties. Verify that in Options, the Recovery Model is Simple. If not,
change it. With the BEDB database selected, start Query Analyzer from the
Tools Menu. The selected database must be BEDB. Enter the following
command without the quotes. 'BACKUP LOG BEDB WITH TRUNCATE_ONLY'. To
shrink the log, enter the following. Run 'sp_helpfile' and note the log
filename. It is probably bedb_log. Enter 'DBCC SHRINKFILE (bedb_log, 1)'.
The file may not shrink to 1Mb, but it should be much smaller. After some
transactions are issued, you can issue the shrinkfile command again and it
will shrink some more. Let the BEWS scheduled maintenance job backup the
database within the next 24 hours or back it up yourself to disk from
Enterprise Manager.

The change to Simple Recovery mode will keep this from happening again.

Alex Moore

"Stanley Yau" wrote in message
news:3ed4bfbd@hronntp01....
> Hallo...
>
> Just two quick questions about the bedb_log.ldf file...
>
> 1. First off, the file has grown to stupidly gigantic proportions - we're
> talking about 4.5GB here! What's the best way of shrinking this down to
> something more respectable?
>
> 2. How do I prevent this from ballooning in size in the future?
>
> Hopefully someone out here will be able to provide a bit of advice. A
scan
> through the manual and support website don't seem to offer anything
helpful.
>
> Cool - thanks in advance!
>
>
>
> --
>
> Stan
>
> --
>
>

Alex

I tried the fix as you detailed in your reply, and after a small bit of
worry (didn't work first time around because I forgot to stop the Backup
Exec services), it sorted out the issue without any problems.

The DB has shrunk from 4.5GB to just slightly over 1MB in size.

Many thanks!



--

Stan

--

"Alex Moore" wrote in message news:3ed4e21f@hronntp01....
> I am assuming that you can connect to the database with an admin id for
that
> database in Enterprise Manager. There are variations of how you could
have
> this setup, so I will not provide details.
>
> From Enterprise Manager, select the BEDB database and right click for
> Properties. Verify that in Options, the Recovery Model is Simple. If
not,
> change it. With the BEDB database selected, start Query Analyzer from the
> Tools Menu. The selected database must be BEDB. Enter the following
> command without the quotes. 'BACKUP LOG BEDB WITH TRUNCATE_ONLY'. To
> shrink the log, enter the following. Run 'sp_helpfile' and note the log
> filename. It is probably bedb_log. Enter 'DBCC SHRINKFILE (bedb_log,
1)'.
> The file may not shrink to 1Mb, but it should be much smaller. After some
> transactions are issued, you can issue the shrinkfile command again and it
> will shrink some more. Let the BEWS scheduled maintenance job backup the
> database within the next 24 hours or back it up yourself to disk from
> Enterprise Manager.
>
> The change to Simple Recovery mode will keep this from happening again.
>
> Alex Moore
>
> "Stanley Yau" wrote in message
> news:3ed4bfbd@hronntp01....
> > Hallo...
> >
> > Just two quick questions about the bedb_log.ldf file...
> >
> > 1. First off, the file has grown to stupidly gigantic proportions -
we're
> > talking about 4.5GB here! What's the best way of shrinking this down to
> > something more respectable?
> >
> > 2. How do I prevent this from ballooning in size in the future?
> >
> > Hopefully someone out here will be able to provide a bit of advice. A
> scan
> > through the manual and support website don't seem to offer anything
> helpful.
> >
> > Cool - thanks in advance!
> >
> >
> >
> > --
> >
> > Stan
> >
> > --
> >
> >
>
>