Take the 2-minute tour ×  My SQL Server 2008 database file
(.mdf) file is nearly 24 MB but the log file grown upto 15 GB.
If I want to shrink database what are the important points to
take into consideration?  Will shrink causes any index
fragmentation and does it affect my database performance?
share|improve this question possible duplicate of How do I
shrink the size of a SQL Server log file –  MattB May 20 '10 at
21:56 add comment  migrated from stackoverflow.com May 20 '10 at
21:12  This question came from our site for professional and
enthusiast programmers.  3 Answers  Your problem is you are not
doing backups on the transaction log and so it cannot drop any
values in the log. This is differnt from backing up the database
and should be done at a minumum daily (we do our every 15
minutes). Shrinking will do you no good at all until you fix
this!  Read the section on Books online on transaction log
backups. This is a required action if you are in full or Bulk-
logged recovery model. Also read the section