Error "Server: Msg 9002, Level 17, State 6, Line 1

Dear expert,
if i have error like this, what should i do ??
"Server: Msg 9002, Level 17, State 6, Line 1
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."

Thank's

Ozhee.
OzheeAsked:
Who is Participating?
 
ram2098Commented:
Other option is to increase the transaction log space for your database.
0
 
ram2098Commented:
Your database Log is full..You need to clear this.

To clear the log, Please run the following command using query analyzer.

backup log dbname --replace dbname with your database name
to disk = 'c:\log.bak'


0
 
AntonGCommented:
alternatively, I seem to think that you server is running out of hard drive space. TempDB should already be set up to automatically increase the size of its oen files. In addition, the tempdb log file should get flushed every time you restart SQL Server.

I have had this problem on numerous occasions whereby I have had to clear HD space in order to rectify this exact problem.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
OzheeAuthor Commented:
thanks.. i just increase the size of log file.
0
 
rhcellxionCommented:
I'm having the same problem, but when I try to backup, it tells me that backup and restore are not allowed on tempdb and it terminates.
0
 
mkacosCommented:
I am having the same problem that rhcellxion is having.  I have plenty of available disk space.  I also believe it is impacting our performance.  Does anyone have the answer?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.