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 ...