Result Sets

statements
#tsql#statements

For descriptions of the RESTORE LABELONLY arguments, see

RESTORE Arguments (Transact-

SQL).

The result set from RESTORE LABELONLY consists of a single row with this information.

Description

Unique identification number of the media set.

Number of media families in the media set.

Sequence number of this family.

Unique identification number for the media family.

Sequence number of this media in the media family.

Whether the media description contains:

= Media description

Media description, in free-form text, or the Tape Format

URL is the format used to specify the location and the file name for Microsoft Azure Blob

Storage and is supported starting with SQL Server 2012 (11.x) SP1 CU2. Although

allow for a consistent and seamless restore experience for all the three devices.

SoftwareVendorId

Mirror_Count

IsCompressed