Thanks a lot Gail for your valuable inputs. Since morning I was manually checking the pages and trying to backtrack the pages to tables manually. So far, I have found...

Hi John,

Thanks a lot for your inputs on this. The issue here is that, the Windows Cluster in being taken care by different vendor and we do not have...

Hi Gail,

Thanks a lot. Yes you are correct regarding the log % usage...only 2% of the log is currently being used. Further I tried to shrink the 296 GB...

Hi Suresh,

I tried the following : select name, log_reuse_wait_desc from sys.databases where database_id = DB_ID('tempdb')

Its showing as "NOTHING".

Hi All,

Thanks a lot for your reply on this. Could you please let me know if the addition of the new log file is possible for TempDB without restarting...

Hi Suresh,

Thanks a lot for your reply. I am using SQL SERVER 2008 ENTERPRISE edition with 32 GB ram. I was just wondering if any kind of programming can...