Home Forums SQL Server 2008 SQL Server 2008 - General Can't shrink physical logfile size. RE: Can't shrink physical logfile size.

  • January 29, 2013 at 1:12 am

    #1581923

    ScottPletcher (1/28/2013)

    SQL will tell you if/why it won't shrink the log:

    SELECT log_reuse_wait_desc, * --col name may be a little off, from memory, but it's at least close

    FROM sys.databases

    WHERE name = 'yourDbName'

    Thanks, didn't know about that column, however it brings back the value 'NOTHING' when queried.

    Could this be anything to do with local resources such as disk space or disk fragmentation? If I restore this database to

    my local instance and back it up, the resultant .bkp file is a quarter of the size of the backup on the server.