Database Reference
In-Depth Information
To restore the SQL database, open Management Studio, right-click Databases,
and choose Restore. Select the Device radio button, and click the ellipsis to
see the screen in Figure 3-5.
Click Add, browse to the
VI_UNData.bak
backup file, and click OK. Type
VI_uNData
in the Database Name field and restore the database.
For restoring the Analysis Services database, ensure that you have Analysis
Services running in tabular mode (you may well need to run the SQL install
again if you chose all the defaults because multi-dimensional is installed by
default), and connect to it in Management Studio.
FIguRe 3-5
Restoring a SQL database
You need to copy the backup to a folder that Analysis Services can access.
You can check what these are by right-clicking the instance and then click-
ing Properties. The information tab has a line item called
BackupDir
as in
Figure 3-6. Copy
OECD_Data.ABF
to this folder.