How to invalidate your recovery in one easy step.

As I've found this "problem" on more than one occasion I thought I'd share the details, hopefully you won't find this -  but  who knows.

Scenario - daily backups of databases, regular transaction log backups.

Issue - what appears to be too much free space in the ldf file, or the perception the ldf file is too large.

Solution - after database backup, backup log with truncate only and shrink the database to recapture free space.

Result - NTFS fragmentation , internal fragmentation - oh and you now can't recover your transaction log backups if an error occurs.

Published 26 October 2006 10:37 by GrumpyOldDBA
Filed under:

Comments

No Comments