Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.