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
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..
This opens the Restore Database dialog box.
4 Where it says Restore:, select From device.
5 In the Parameters section, click the Select Devices button.
This opens the Choose Restore Devices dialog box.
6 In the Restore From section, select Disk and then click the Add button.
This opens the Choose Restore Destination dialog box.
7 Select File Name and enter the name and location of the short_drinks_backup file in the text box.
8 Click OK to returns to the Choose Restore Devices dialog box, and then click OK again to return to the Restore Database dialog box.
9 Select Restore backup set and beneath that, Database - complete.
10 Select the Options tab and then select 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 should now restore the short_drinks database.
Note 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
See also