December 22, 2009 at 9:12 am
what will happen if we shrink the database on daily basis..any drawbacks?(both ldf and mdf)
December 22, 2009 at 9:22 am
Yes. First, if you shrink it, it will just have to grow again. You should size your database (mdf file) such that it has sufficient space for 3 to 6 months growth without having to autogrow. You, as the DBA, should control when it grows. As for the log file (ldf), that should be sized to handle the normal day to day activity without growing. You may want to add a bit for extraordinary activity, but that could be covered by autogrowth if it doesn't occur often.
Relying on autogrowth all the time can result in serious file level fragmentation of your database and log files. Also, every time either has to grow there is an impact on system performance as the database as to stop work while growing the mdf or ldf files.
December 22, 2009 at 9:33 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply