Solved

SQL Server, 2000 - The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.

Posted on 2007-11-28
6
1,858 Views
Last Modified: 2008-02-01
I am executing a script that loops into my table, and I get this after around 10 minutes of waiting!

--------------------------------------------------------------
Server: Msg 9002, Level 17, State 2, Line 11
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
0
Comment
Question by:feesu
  • 3
  • 2
6 Comments
 
LVL 1

Expert Comment

by:Alex342
ID: 20371690
change growth rate  to 10 mega and unrestricted
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20371696
1. Use  DBCC SHRINKFILE() and DBCC SHRINKDATABASE()
2. restart the SQL Server service
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 20371743
option 3 :

. run  BACKUP LOG tempdb WITH TRUNCATE_ONLY
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:feesu
ID: 20371751
I tried the shrink, it didn't work.
How do i do the backup log thing? Do i execute a statement?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20371777
yes You need to run it
0
 

Author Comment

by:feesu
ID: 20371844
Worked perfectly. Thanks.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IF SQL Query 12 27
T-SQL: Stored Procedure Syntax 3 29
SQL 2014 missing dll from Bin? 3 31
SQL Syntax 6 27
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question