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

FIGURE 39.5

The Restore Database dialog box offers options for your restore operation.

Using the DDL Command to Restore Your Database

If you prefer, you can work directly with the DDL command to restore your database,
instead of using the Restore Database dialog box user interface. The easiest way for us to
explain this is to use the Script function of the dialog box.

NOTE
You can also use any text editor to write your own command. If you save it with the
extension .xmla , you can use SQL Server Management Studio to send your command
directly to Analysis Server.

Along the top of the right pane in the Restore Database dialog box, you'll find a series of
buttons. Click the button labeled Script. If you move back to SQL Server Management
Studio, you'll see a command script that reflects the options you selected in the dialog box.

If you right-clicked Databases and selected Restore from the contextual menu, selected
FoodMart 2008.abf in the From Backup File box in the Restore Database dialog box
options, and then clicked Script, you would see the command shown in Listing 39.4.

LISTING 39.4

A Simple DDL Restore Command

<Restore xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<File>C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Backup\FoodMart
2008.abf</File>