How to create a database backup (Enterprise Manager)

To create a database backup

  1. Expand a server group; then expand a server.
  2. Expand Databases, right-click the database, point to All Tasks, and then click Backup Database....
  3. On the General tab, in Name, enter the backup set name.
  4. Optionally, in Description, enter a description of the backup set.
  5. Under Backup, select Database - complete.
  6. Under Destination, click Add... to add an existing or create a new backup device, or click Remove to remove a backup device from the list of backup devices to be used.
  7. In the SQL Server Backup dialog box, under Overwrite, select:
  8. Optionally, select Schedule to schedule the backup operation for later or periodic execution.
  9. Optionally, click the Options tab and select from these backup options:
  10. If it is the first use of the backup media, or you want to change an existing media label, under Media set labels, select Initialize and label media, and enter the media set name and media set description. The media can only be initialized and labeled when overwriting the media.
See Also
Appending Backup Sets to Existing Media Creating and Restoring Differential Database Backups
Backing Up the master Database Deleting a Database
Backing Up the model, msdb, and distribution Databases Overwriting Media
Copying Databases Using Differential Database Backups with Transaction Log Backups
Creating and Applying Transaction Log Backups Using Media for the First Time
Creating and Restoring a Database Backup Verifying Backups

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.