SQL Server How To: Transaction Log Maintenance for Painless Data Recovery
October 13, 2008[From Datamation]
Data is your business, and maintaining a healthy backup and recovery plan is vital to protecting your data.
SQL Server's transaction logs, which bridge the most recent changes to the last backup, should be a part of that backup and recovery plan. Without a healthy, well-maintained transaction log, you can recover old data but your users will still have to re-enter all of their changes since the last backup. Fail to maintain transaction logs and you may fail to keep your job. Fortunately, SQL Server's transaction logs are easy to maintain.