log file usage issue

  • 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.

  • take a back up once.

    then perform DBCC shrink command.

  • 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
  • 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