The backed-up object: Database, File, or (for transaction logs). A backup set is the result of a successful backup operation, whose content is distributed among the media on the set of backup devices.
Each media set contains one media family per separate device (or group of mirrored devices) for instance, if a media set uses two non-mirrored backup devices, the media set contains two media families.ĭisplays information about the backup set or sets contained on the media. All the output to a given single backup device (or group of mirrored backup devices) forms a single media family. Each media set is a collection of one or more media families. When the backup set is restored, the media sequence numbers ensure that the operator restoring the backup mounts the correct media in the correct order.ĭisplays the creation date and time of the media set.Ī media set is an ordered collection of backup media to which one or more backup operations have written by using a constant number of backup devices.ĭisplays the name of the media set, if any.ĭisplays the description of the media set, if any.ĭisplays the number of families in the media set. The initial backup media is tagged with 1, the second (the first continuation tape) is tagged with 2, and so forth. The physical backup media are each tagged with a media sequence number that indicates the order in which the media were used.
Lists the media sequence number, the family sequence number, and the mirror identifier, if any. View information about the individual media, media set, and backup sets.Ī disk or set of tapes on which backup information is stored. View the Properties and Contents of a Logical Backup Device (SQL Server) View the Contents of a Backup Tape or File (SQL Server) To use SQL Server Management Studio to view the contents of a backup device This information describes the device, the media, the media set, and the backup set or sets. Use the Backup Device dialog box to view the backup information.
0 kommentar(er)
