SQL Server: Hidden risks of using DBCC SHRINKFILE

8.5k Views Asked by At

We're getting a huge LDF file by using a full recovery mode in a SQL Server DB. so we're planning to shrink the log file.

Is there any performance penalty for using DBCC SHRINKFILE to reduce the database log file size (LDF)?

and what about applying it to the data file (MDF)?

1

There are 1 best solutions below

2
On BEST ANSWER

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