Sometime we may face an error in SQL Server while performing some transaction
ERROR - (Error 9002)
The following SQL Server Error or errors occured when accessing the "Table Name" table:
9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for
database 'Database name' is full. To find out why space in the log cannot be reused, see the
log_reuse_Wait_desc column in sys.database.
SQL:
Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where
query.
Reason For Error-
The error is due to space avilability in the disk where Log file reside.
Resoultion -
There are multiple options for the resoultion of the same, choose one that best suite you-
1) Backing up the Log.
2) Freeing Disk Space.
3) Moving the Log File to a Different Disk
4) Increasing the size of a log file.
5) Adding a log file on a different disk.
6) Completing or killing a long-running transaction.
ERROR - (Error 9002)
The following SQL Server Error or errors occured when accessing the "Table Name" table:
9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for
database 'Database name' is full. To find out why space in the log cannot be reused, see the
log_reuse_Wait_desc column in sys.database.
SQL:
Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where
query.
Reason For Error-
The error is due to space avilability in the disk where Log file reside.
Resoultion -
There are multiple options for the resoultion of the same, choose one that best suite you-
1) Backing up the Log.
2) Freeing Disk Space.
3) Moving the Log File to a Different Disk
4) Increasing the size of a log file.
5) Adding a log file on a different disk.
6) Completing or killing a long-running transaction.
