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,840 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now