Backing up and restoring the tail-log end of a transaction log
In this post I would like to demonstrate with a hands-on example how to backup and restore the tail of the transaction log.In this post I will also demonstrate how to take full and differential backups and how to restore them. I will also talk about the various SQL Server backup types, recovery models and how these models affect our backup and restore strategy. (
read more)