1: Data Warehouse Architecture Backup
Architecture and OLAP architecture including the database;
The database includes dimension, factories, and other temporary or control class tables, which are generated by "generating SQL scripts".
Note: It is generated by the primary key, index, etc.
OLAP's architecture is saved in the default state in "C: / Program Files / Microsoft Analysis Services / Bin / MSMDQLOG.MDB" data
In the library, you can back up it;
It is highly recommended to migrate its knowledge base and save it in SQL Server so that efficiency can be improved. It is not recommended to save in MSDB, it is recommended to establish specialized knowledge
The library is saved, it is also convenient to back up;
2: Data Warehouse Architecture and Data Backup
The contents of the backup in the three in ROLAP, HOLAP, MOLAP are different!
In three ways, the dimensions in the database are backup, and under MOLAP, the fact table does not need to be backed up; ROLAP mode, also included generated
Collection table;
Use the database backup or export data with DTS;
OLAP's backup uses Analysis Services's data inventory file!
The architecture of the data warehouse also includes aggregation data!
