EventViewer Application log showing error Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below.

Avyayah 1,251 Reputation points
2021-01-27T18:37:04.097+00:00

Error:

Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below.

The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.

This is caused one of the site to not launch because of the error. Temp db database was recreated on Jan24th and of course it is never backup. Running the disc usage report see the transactional log is 60% Unused and 39% used. We increased space in transactional logfile, which gave me access to SSMS. There are 6 databases whre the Log Space Used is more than 45%. Do I need to shrink the logfile in any of those databases. Logfile was not full in any of the databases.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 102.3K Reputation points
    2021-01-27T22:44:19.78+00:00

    Do I need to shrink the logfile in any of those databases.

    No. Shrinking a database file is an exceptional action. And if you get a problem in one database, there is even less reason to fiddle with the log in another database, be that tempdb or something else.