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