SQL Server Performance

Log filled up disk

Discussion in 'T-SQL Performance Tuning for Developers' started by TRACEYSQL, Jul 3, 2007.

  1. TRACEYSQL New Member

    Right now im trying to get up my cluster for SQL as one of the LOG Database grew out of control.

    When i finally get up system.

    To clear out the LOG which is 32 gig

    Do i just right click in enterprise and do srhink log file.


    Thanks
    TRACEYSQL, Jul 3, 2007
    #2

  2. satya Moderator

    Transaction log out of hands, in this case you have to check whether transaction log backup is performed regularly.
    Also check what kind of processes, queries running on the server causing this Tr.log to grow.
    There is no use in shrinking the log if other processes are contributing a lot, by performing regular backups you can control the sizes, for the sake of recoverability it is better to take care with backup and not to put as SIMPLE recovery model.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 5, 2007
    #2

Share This Page