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.
Search WWH ::




Custom Search