Viewing 6 posts - 181 through 186 (of 186 total)
So shrinking only log file will not increase the fragmentation?
January 16, 2013 at 6:43 am
I used the SSMS gui option to restore the file group.
January 16, 2013 at 5:59 am
Yes, Auto close is set to true.The recovery model is full.
January 16, 2013 at 5:37 am
Thnk u anthony for your reply
But i found that this in recovery message not only comes after restarting the sql server. Sometime it comes and again goes off after 10...
January 16, 2013 at 5:28 am
January 16, 2013 at 5:23 am
So log backup only reuse the space. But shrinking the log file will increase fragmentation ryt? So is it good habit to shrink the log file?
January 15, 2013 at 5:59 am
Viewing 6 posts - 181 through 186 (of 186 total)