• zi (4/25/2013)


    Dear Experts

    should i delete the log file

    Thanks

    Please don't try this ever.

    Just try this.

    select log_reuse_wait_desc,* from sys.databases where name='dbname'

    -- see what it is waiting on

    also run this dbcc sqlperf(logspace)

    -- see log space utilization

    M&M