SQL Server How To: Transaction Log Maintenance for Painless Data Recovery

Monday Oct 13th 2008 by DatabaseJournal.com Staff

Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.

[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.

The article continues at http://itmanagement.earthweb.com/netsys/article.php/3777461/SQL+Server+How+To:+Transaction+Log+Maintenance+for+Painless+Data+Recovery.htm

Mobile Site | Full Site