Problem with bedb_log.ldf filesize - Veritas Backup Exec

This is a discussion on Problem with bedb_log.ldf filesize - Veritas Backup Exec ; 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 ...

+ Reply to Thread
Results 1 to 3 of 3

Thread: Problem with bedb_log.ldf filesize

  1. Problem with bedb_log.ldf filesize

    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

    --



  2. Re: Problem with bedb_log.ldf filesize

    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
    >
    > --
    >
    >




  3. Re: Problem with bedb_log.ldf filesize

    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
    > >
    > > --
    > >
    > >

    >
    >




+ Reply to Thread