[dba-SQLServer] full transaction logs

Arthur Fuller fuller.artful at gmail.com
Thu Sep 11 04:50:06 CDT 2008


Thanks for that, Asger. I will bring it up at our next meeting (I'm the new
guy on this team so the decision won't necessarily be in my hands, but on
the other hand I am respected for having resources like this group at my
fingertips).

Thanks,
Arthur

On Wed, Sep 10, 2008 at 8:09 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> Just a second comment for Arthur:
>
> You wrote: "Now we back up the log (only the log) four times a day and
> nightly do a dbcc shrinkfile"
>
> To my mind a DBCC SHRINKFILE is an emergency command which should NOT be
> included in an automated administrative task.
>
> DBCC SHRINKFILE will free truncated file-space to the operating system.
> This
> may be a reasonable action if the log-file has been bloating. Otherwise it
> certainly is not: freeing truncated file-space to the operation system will
> force SQL Server to allocate new file-space for the log as needed, and this
> will be a great invitation for file fragmentation at the disk level.
>
> Asger
>



More information about the dba-SQLServer mailing list