O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required