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.


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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.