Backup and Restore Strategies with SQL Server 2000

Overview Information technology (IT) professionals fall into one of two categories: those who have already experienced a significant data loss, and those who will. The survivors will be clearly distinguished from the casualties by the planning and implementation of their backup and restore strategies. This article discusses the costs incurred from data loss and the leading contributors to data loss. It also reviews how to plan a backup and restore process and describes data protection strategies using SQL Server 2000 Enterprise to back up SQL Server 2000 databases. Information technology (IT) departments today must seriously engage in a working and targeted data protection plan. Without a clear commitment to protecting corporate data, organizations will inevitably experience a compromise of data integrity, possibly resulting in permanent loss of data. However, proper planning and implementation can mitigate much of the risk of data loss.