开发者

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜