Thursday, May 24, 2012

TEMPDB issue in SQL server

Today I had received a call from one customer that they are getting error of TempDB.

“The log file for database ‘tempdb’ is full. Back up the transaction log for the database to free up some log space.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.”

One thing we should note here that TempDB is a sensitive database so shrinking of log file may cause data corruption

So First I had taken backup of tempdb on live server downloaded it on local system and attached and change the database mode in Simple and then given following command in Local SQL Server Management Studio.


I got a message

“Server: Msg 2501, Level 16, State 1, Line 1 Could not find table named ’1525580473'. Check sysobjects. “

After this I had taken backup of this local Tempdb of which size was reduced drastically and again uploaded on live server and attached by stoping SQL Server and then restarted SQL Server of live server.

After this i got confirmation from customer that now itw working properly and tranasactions are getting processed fastly.

No comments:

Post a Comment