The log file for database 'temdb' is full

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tmssupport - 31 Mar 2008 11:15 GMT

Server generated an error 9002, Severity:17, State 6
The log file for database 'temdb' is full. Back up the transaction log for
the database to free up some log space.

tempdb.mdf file located at D:\Microsoft SQL Server\MSSQL\Data\ is with size
554,304KB. Harddisk still has plenty of space.

What is triggering the error. How to solve. Thank you

Reply to this Message

Uri Dimant - 31 Mar 2008 12:50 GMT

Hi
http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-preve
nt-this-from-happening.html

> Server generated an error 9002, Severity:17, State 6
> The log file for database 'temdb' is full. Back up the transaction log for
[quoted text clipped - 5 lines]
>
> What is triggering the error. How to solve. Thank you

Reply to this Message