Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2367
  • Last Modified:

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.
0
Ozhee
Asked:
Ozhee
1 Solution
 
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
 
ram2098Commented:
Other option is to increase the transaction log space for your database.
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now