Answer:
Normally the Transaction Log full Err occurred with 9002 Error code.
1. Backing up and Truncating the log.
2. Freeing the transaction physical disk space so that the log can automatically grow.
3. Moving the log file to a different disk drive with sufficient space.
4. Increasing the size of a log file(Initial and Growth).
5. Completing or killing a long-running transaction.
Asked In: Many Interviews |
Alert Moderator