Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Identifying the Backup Set to Restore

Identifying the Backup Set to Restore

SQL Server 2000

Identifying the Backup Set to Restore

Each backup set on media, including foreign backup sets such as Microsoft® Windows NT® 4.0 file backups, is numbered. This allows the backup set you want to restore to be referenced easily. For example, the following media contains four backup sets: two Microsoft SQL Server™ backups and two foreign backup sets (for example, Windows NT 4.0 files).

To restore a specific backup set, specify the position number of the backup set you want to restore. For example, to restore the second SQL Server backup set, the fourth backup set on the media, specify 4 as the backup set to restore.

To restore a specific database backup

Transact-SQL

Enterprise Manager

SQL-DMO

See Also

BACKUP

Viewing Information About Backups

Show:
© 2015 Microsoft