Performing Database, Transaction Log, Differential, and File/File Group Backups

SQL Server 2000 eases the pain of the backup process by providing a common interface for backups. Whether you are performing a database backup, differential backup, File/Filegroup backup, or transaction log backup, the same steps are followed. Examine the steps required to perform a database backup or transaction log backup using the SQL Server Enterprise Manager.

TIP

Because of many different storage and engine changes made in SQL Server 7.0 and 2000, it is not necessary to run DBCC's commands before performing a database backup. However, if you are a DBA from the SQL Server 6.x school, you can still execute the commands for peace of mind. For SQL Server 2000, the ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.