Post reply

log file usage issue

  • July 12, 2013 at 7:39 am

    #275982

    HI all

    here sql server log file usage is showing as 100% in task manager but internally it is showing as 1mb only how to solve this issues.

  • July 12, 2013 at 10:08 am

    #1632036

    take a back up once.

    then perform DBCC shrink command.

  • July 12, 2013 at 10:11 am

    #1632038

    nagkarjun1 (7/12/2013)

    take a back up once.

    then perform DBCC shrink command.

    No.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 12, 2013 at 10:12 am

    #1632039

    New persopn (7/12/2013)

    here sql server log file usage is showing as 100% in task manager but internally it is showing as 1mb only how to solve this issues.

    What do you mean by 'showing 100% in Task Manager'? What exactly are you looking at?

    Can you describe in detail what you're seeing and where you're seeing it?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply