winmansoft (1/16/2013)
So shrinking only log file will not increase the fragmentation?
Shrinking the data file will cause fragmentation within the database, and as Gail has stated, regular shrinking in general (both Log and Data) will lead to fragmentation at the filesystem level. And if you're using RAIDed storage, defragmenting such storage devices will take a considerable amount of time (which your SQL Server will be unavailable).
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience