SQL Server: Hidden Risks of Using DBCC SHRINKFILE

Question

We get a huge LDF file using the full recovery mode in the SQL Server database. therefore, we plan to compress the log file.

Is there a performance limitation for using DBCC SHRINKFILE to reduce the size of the database log file (LDF)?

and how to apply it to a data file (MDF)?

Answer 1

I think this should be useful: http://www.mssqltips.com/tip.asp?tip=2055