Applies To: SQL Server 2016 Preview

Returns information about the contents of a backup file. You must have permission to access the backup file location.

The DISCOVER_LOCATIONS rowset contains the following columns.

Column nameType indicatorRestrictionDescription
LOCATION_BACKUP_FILE_PATHNAMEDBTYPE_WSTRRequired, see below.The location of the backup file.
LOCATION_PARTITION_OBJECTPATHDBTYPE_WSTRThe path to the partition relative to the data folder.
LOCATION_PARTITION_DATASOURCEIDDBTYPE_WSTRThe data source ID used for processing the partition.
LOCATION_PARTITION_DATASOURCENAMEDBTYPE_WSTRThe name of the data source used for processing.
LOCATION_PARTITION_SIZEDBTYPE_WSTRThe approximate size of the partition.
LOCATION_CONNECTION_STRINGDBTYPE_WSTRThe connection string for the data source used in processing.
LOCATION_PARTITION_FOLDERDBTYPE_WSTRThe original location of this partition when the backup file was produced.

This schema rowset is not sorted.

The DISCOVER_LOCATIONS rowset can be restricted on the columns listed in the following table.

Column nameType indicatorRestriction state
LOCATION_PASSWORD PF_DBTYPEDBTYPE_WSTRRequired if it was specified during backup. This restriction is not used to restrict the rows returned. It is used to provide the password to access the location.

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.


XML for Analysis Schema Rowsets

Community Additions