I have been receiving following question again and again either through email or through comments on this blog.
My log file is too big, what should I do?
Answer to this question is in three steps.
- Backup the log file to any device.
- Truncate the log file.
- Shrink the log file.
I have previously written two article about this issue. Refer them for additional information and details.
SQL SERVER - Shrinking Truncate Log File - Log Full(Script)
SQL SERVER - Shrinking Truncate Log File - Log Full - Part 2(Management Studio)
pinaldave
