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
http://go.microsoft.com/fwlink/events.asp.
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 是自动扩展，且没有大小限制， 为什么会报出这样的错误呢 ？
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-662206/ ，如需转载，请注明出处，否则将追究法律责任。
