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