ramyours2003 (7/16/2013)
what are the possible reasons when a query is timed out ?
The query took longer than the application's timeout setting.
what are the possible reasons for not truncating the log file ?
There are no good reasons for not truncating the transaction log, unless you want to test what happens when the log runs out of space.
i have Log file of 5 GB how many VLF"s will be present ?
2 or more.
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