Backup and Restore Operations - Microsoft SQL Server 2008 Analysis Services - page 797

<Security>SkipMembership</Security>
</Restore>

Its designers built in to Analysis Services both simplicity (as shown in the preceding
example) and power to execute restore for the most complex configurations. Power is
provided by the options that you can add to the DDL command. The complete set of
options for the Restore command appears in Listing 39.5, with the default values in bold.

LISTING 39.5

The Complete Set of Restore Command Options

<Restore>
<File>BackupFile</File>
[<DatabaseName>DatabaseName</DatabaseName>
<DatabaseID>DatabaseID</DatabaseID>]
[<AllowOverwrite>true/ false </AllowOverwrite>]
[<Locations>
[<Location>
[<File>BackupFile</File>]
<DataSourceID>DataSource ID</DataSourceID>
[<DataSourceType>Remote|Local</DataSourceType>]
[<ConnectionString>Analysis Server Connection string</ConnectionString>]
[<Folders>
[<Folder>
<Original>old folder</Original>
<New>new folder</New>
</Folder>]
<Folders>]
</Location>]</Locations>]
[<Security> CopyAll | SkipMembership </Security>]
[<Password></Password>]
</Restore>

For an explanation of these options, see the previous section, “Using the Restore Database
Dialog Box.”

Using DISCOVER_LOCATIONS to Specify Alternative Locations for
Partitions
When you restore a database with partitions that are not located in the default Data
folder, you have to find the locations of the partitions so that you can specify the alterna-
tive locations. To look into a backup file and find the locations of partitions, you use the
DISCOVER_LOCATIONS mechanism. You can issue the DISCOVER_LOCATIONS request against
Analysis Server and restrict it with the name of your backup file. You can get two pieces of
important information with DISCOVER_LOCATIONS : the location of the database's partitions