Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server: Hidden risks of using DBCC SHRINKFILE

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)?

like image 214
SDReyes Avatar asked Oct 14 '22 00:10

SDReyes


1 Answers

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

like image 182
Sidharth Panwar Avatar answered Nov 04 '22 01:11

Sidharth Panwar