Ali_SQLDBA (1/9/2010)
I am also facing the same problem. Today, our disk which holds the LDF's ran out of space, as a temporary action, I ran shrink on ldfs through management studio leaving all defaults checked. We have rebuild and Update stats running this night and they both failed showing the same error message as posted in the first post. Do you think increasing the disk space resolves this issue?
S u need to increase the disk space.
What's ur t-log size ?
What's the size of Auto growth ?
How much free space do u have in ur drive (T-log resides)
Also,Don't shrink the t-log files.(If u have no other way then u can)
Find the % of log used using Dbcc Sqlperf
I'd suggested read following article
Read the Gail's article Managing Transaction Logs[/url]
Edit:Added more info.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/