SQL Server Performance

Keep translogs in check

Discussion in 'Third Party Tools' started by loiter99, Jan 27, 2006.

  1. loiter99 New Member

    I have been having problems with my transaction logs growing too big. I am using litespeed, but it seems as soon as they get over 2 gigs the Litespeed job freezes up. THEY claim it is a problem with the MS native command.

    Anyways, I am looking for a script or a some way to backup the trans logs, truncate them and then free any space bringing them back to their default size.

    Please help.

  2. Luis Martin Moderator

    I`ve moved to 3rd party tools.

    I suggest to ask Quest about litespeed.

    Take a look of backup transaction log in BOL.

    Luis Martin

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page