Hi
http://sqlserver2000.databases.aspfa...happening.html



"tmssupport" <tmssupport@discussions.microsoft.com> wrote in message
news:2CD39F89-5070-4C76-B7CB-BF5DB716C05D@microsoft.com...
> 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
>