Restoring the Short Drinks sample database

Developer Documentation Library > Data Model > UNICOM Intelligence Data Model samples > Sample data > Restoring the Short Drinks sample database

By default, the backup of the database is called short_drinks_backup and is installed into the [INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\RDB folder. If you are restoring the database onto a server, you will need to copy this file onto the server before you begin.

The procedure for restoring the database depends on the version of the SQL Server client tools that you are using.

Using Microsoft SQL Server to restore the database

1 Create a new SQL Server database called short_drinks. For more information, see Creating a new SQL Server database.

2 Navigate to the new short_drinks database in SQL Server Enterprise Manager.

3 Right-click the new short_drinks database and then click All Tasks > Restore Database..

The Restore Database dialog opens.

4 Where it says Restore:, select From device.

5 In the Parameters section, click Select Devices.

The Choose Restore Devices dialog opens.

6 In the Restore From section, select Disk, and then click Add.

The Choose Restore Destination dialog opens.

7 Select File Name, and then enter the name and location of the short_drinks_backup file in the text box.

8 Click OK to return to the Restore Database dialog.

9 Click Restore backup set and Database - complete.

10 Click the Options tab, and then click Force restore over existing database.

11 In the Restore Database Files As section, make sure that the file locations that appear in the Move To Physical File Name column are valid for your system.

12 Click OK.

SQL Server restores the short_drinks database.

If you are using the short_drinks database with UNICOM Intelligence Reporter, you must also set up access to the database for the anonymous user. For more information, see Setting up access for the anonymous user.

Requirements

Microsoft SQL Server Client Tools