How To (SQL Server 2000)
Backing Up and Restoring Databases
The backup and restore component of Microsoft® SQL Server™ provides an important safeguard for protecting critical data stored in SQL Server databases. Understanding how to create and restore database, differential database, transaction log, and file and filegroup backups helps you implement this important safeguard.