Home » error 9002 sql server 2016

error 9002 sql server 2016

sql server DBA 999

SQL Server Error : 9002 Severity: 17. The transaction log for database ‘%.*ls’

SQL Server Error : 9002 Details

SQL Server Error: 9002 Severity: 17 Event Logged or not: Yes Description: The transaction log for database ‘%.*ls’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Severity 17 Description: Indicates that the statement caused SQL Server to run out of resources (such as memory, locks, or disk space for the database) or to exceed some limit set by the system administrator.

The SQL Server Database Engine error occurs when the transaction log is complete. The log can be filled in online or recovery time the database is in. The database remains online but can only be read and … Read the rest