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.

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.
feesuAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
option 3 :

. run  BACKUP LOG tempdb WITH TRUNCATE_ONLY
0
 
Alex342Commented:
change growth rate  to 10 mega and unrestricted
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
1. Use  DBCC SHRINKFILE() and DBCC SHRINKDATABASE()
2. restart the SQL Server service
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
feesuAuthor Commented:
I tried the shrink, it didn't work.
How do i do the backup log thing? Do i execute a statement?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
yes You need to run it
0
 
feesuAuthor Commented:
Worked perfectly. Thanks.
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.