Export (0) Print
Expand All

How to restore a backup from a backup device (Enterprise Manager)

SQL Server 2000

How to restore a backup from a backup device (Enterprise Manager)

To restore a backup from a backup device

  1. Expand a server group, and then expand a server.

  2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.

  3. In the Restore as database box, type or select the name of the database to restore if different from the default. To restore the database with a new name, type the new name of the database.

    Note  Specifying a new name for the database determines automatically the new names for the database files restored from the database backup.

  4. Click From device, and then click Select devices.

  5. Under Restore from, click Tape or Disk, and then select a device from which to restore.

    If no devices appear, click Add to add an existing backup device or to create a new one. In the Restore Database dialog box, click View Contents and select the backup set to restore.

    Note  This option scans the backup set for the backup content information and can be time consuming, especially when using tape devices. If you already know the backup set to restore, type the backup set number in Backup number instead.

  6. Under Restore backup set, do one of the following:
    • Click Database - complete to restore a database backup.

    • Click Database - differential to restore a differential database backup.

    • Click Transaction log to apply a transaction log backup.

    • Click File or filegroup to restore a file or filegroup backup. Specify the name of the file or filegroup.
  7. Optionally, click the Options tab, and then do one of the following:
    • Click Leave database operational. No additional transaction logs can be restored if no further transaction log backups are to be applied.

    • Click Leave database nonoperational, but able to restore additional transaction logs if another transaction log backup is to be applied.

See Also

Transaction Log Backups

Database Backups

Differential Database Backups

Identifying the Backup Set to Restore

Rebuilding the master Database

Restoring a Database to a Prior State

Restoring the master Database from a Current Backup

Restoring the model, msdb, and distribution Databases

Using Differential Database Backups with Transaction Log Backups

© 2014 Microsoft