Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to back up files and filegroups (Enterprise Manager)

How to back up files and filegroups (Enterprise Manager)

SQL Server 2000

How to back up files and filegroups (Enterprise Manager)

To back up files and filegroups

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

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

  3. In the Name box, type the backup set name. Optionally, in Description, type a description of the backup set.

  4. Under Backup, click File and filegroup,and then click the browse (...) button.

  5. In the Specify Filegroups and Files dialog box, select a Backup for each filegroup or file you want to back up.

    By selecting a filegroup name, all the files within the filegroup are selected automatically.

  6. Under Destination, click Tape or Disk, and then specify a backup destination.

    If no backup destinations appear, click Add to add an existing backup destination or to create a new one.

  7. Under Overwrite, do one of the following:
    • Click Append to media to append the backup to any existing backups on the backup device.

    • Click Overwrite existing media to overwrite any existing backups on the backup device.
  8. Optionally, the Schedule check box to schedule the backup operation for later or periodic execution.

  9. Optionally, click the Options tab, and then do one or more of the following:
    • Select the Verify backup upon completion check box to cause the backup to be verified when backed up.

    • Select the Eject tape after backup check box to cause the tape to be ejected when the backup operation has completed. Available only with tape devices.

    • Select the Check media set name and backup set expiration check box to cause the backup media to be checked to prevent accidental overwrites. In Media set name, type the name of the media to be used for the backup operation. Leave blank when specifying only the backup set expiration.
  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 the Initialize and label media check box and type the media set name and media set description. The media can be initialized and labeled only when it is being overwritten.

See Also

Using File Backups

© 2015 Microsoft