Export (0) Print
Expand All

DISCOVER_LOCATIONS Rowset

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 name

Type indicator

Restriction

Description

LOCATION_BACKUP_FILE_PATHNAME

DBTYPE_WSTR

Required, see below.

The location of the backup file.

LOCATION_PARTITION_OBJECTPATH

DBTYPE_WSTR

 

The path to the partition relative to the data folder.

LOCATION_PARTITION_DATASOURCEID

DBTYPE_WSTR

 

The data source ID used for processing the partition.

LOCATION_PARTITION_DATASOURCENAME

DBTYPE_WSTR

 

The name of the data source used for processing.

LOCATION_PARTITION_NAME

DBTYPE_WSTR

 

The partition name.

LOCATION_PARTITION_SIZE

DBTYPE_WSTR

The approximate size of the partition.

LOCATION_CONNECTION_STRING

DBTYPE_WSTR

The connection string for the data source used in processing.

LOCATION_PARTITION_FOLDER

DBTYPE_WSTR

The 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 name

Type indicator

Restriction state

LOCATION_BACKUP_FILE_PATHNAME

DBTYPE_WSTR

Required

LOCATION_PASSWORD PF_DBTYPE

DBTYPE_WSTR

Required 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.

Argument

Value

GUID

a07ccd92-8148-11d0-87bb-00c04fc33942

ADOMDNAME

Locations

Community Additions

ADD
Show:
© 2014 Microsoft