Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
Medium Priority
?
1,882 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 total points
ID: 20371743
option 3 :

. run  BACKUP LOG tempdb WITH TRUNCATE_ONLY
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

598 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