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)
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
How to shrink the database not the the log file
Best regards
Sayed
Saudi Arabia