How to respond to a Full Transaction Log Error in SQL Server ?

Posted by PandianS on 9/19/2010 | Category: Sql Server Interview questions | Views: 4561 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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