Shrink Sql Server database
- by hani
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?