July 30, 2009 at 11:24 am
Can some one answer the below questins
Assume that I have the below problem
My tempdb log file is full and I need to troubleshoot...
I tried the below optins
1. Tried to Shrink the log file no solution -- May be some open tran.. and killed and those are in roll back state...
2. Ran Backup log tempdb with truncate_only -- No use...
some times it works some times it does not work....
Is there any way to increase the tempdb log size, I know that If I alter the tempdb it will not be effected until you stop and start the SQL Server.
I am getting confusion on working tempdb issue, I do not why people ask this question often even though they are not facing this issue....
If you are being asked
Your tempdb is full and you need to resolve it and you should not reboot the SQL Server what is your answer?
Rajesh Kasturi
July 30, 2009 at 11:48 am
Please don't double-post. This is a duplicate of your other post on another forum on this site.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 30, 2009 at 12:28 pm
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic762623-146-1.aspx
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply