Since SQL Server version 2000 better enhancement of three types of recovery models: simple, full and bulk-logged are fetching long-run support for all kinds of database activies. As you know such recovery models offer varying levels of recovery for restoring your databases from your backups, overall...
I always see many posts in the forums asking about transaction log backups and their importance. For the point in time recovery they are must in order to provide the data upto date or atleast that are committed. Yet I have seen many articles out there explaining the importance and tasks for every DBA...