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

Monday Oct 13th 2008 by DatabaseJournal.com Staff
Share:

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved