Error: 9002, Severity: 17, State: 6

Windows 2003  ,  SQL Server 2000 SP4    

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 5/7/2010
Time: 9:43:01 AM
User: N/A
Computer: SQLAPPDB
Description:
Error: 9002, Severity: 17, State: 6

The log file for database 'tempdb' is full. Back up the transaction log for the

database to free up some log space.

For more information, see Help and Support Center at

.

Data:

0000: 2a 23 00 00 11 00 00 00 *#......
0008: 09 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 41 00 50 00 50 00 L.A.P.P.
0018: 44 00 42 00 00 00 05 00 D.B.....
0020: 00 00 44 00 45 00 4c 00 ..D.E.L.
0028: 4c 00 00 00 L...  

 

-----------------------------------------------------------------------------------

 

1. 清空日誌  
  DUMP     TRANSACTION     tempdb     WITH     NO_LOG           
    
 2. 截斷事務日誌：  
  BACKUP   LOG   tempdb   WITH   NO_LOG   
    
 3. 如果還不行,重新啟動SQL服務.

 

不過設定的tempdb的log 是自動擴充套件，且沒有大小限制， 為什麼會報出這樣的錯誤呢 ？