开发者

SQL Server: Hidden risks of using DBCC SHRINKFILE

开发者 https://www.devze.com 2023-01-15 00:41 出处:网络
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.

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 a开发者_StackOverflow中文版ny performance penalty for using DBCC SHRINKFILE to reduce the database log file size (LDF)?

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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消