Databases Reference
In-Depth Information
Planning Your Backup Operation
When you're planning to back up your database files, a number of factors determine which
approach is best for your operation:
.
The size of the database to be backed up
.
The type of storage you use for dimensions and partitions (ROLAP/MOLAP/HOLAP)
.
The amount of time allocated for the backup operation
.
High-availability requirements
NOTE
You can't use the Analysis Services backup function to back up a relational database.
Figure 39.1 shows an example of different storage modes for Analysis Server objects.
Analysis Server can back up multidimensional online analytical processing (MOLAP)
objects, but it cannot back up relational online analytical processing (ROLAP) objects.
Three MOLAP partitions are shown in Figure 39.1. Two partitions (
Part1
and
Part2
) store
their files in the
Data
directory.
Part3
's files are located in
c:\dir3
. Analysis Server can
back up these files.
The figure also shows two partitions:
Part1R
and
Part2R
. These partitions depend, respec-
tively, on the SQL Server tables
Tab1R
and
Tab2R
. We use the
R
to indicate that these parti-
tions are ROLAP partitions. Analysis Server cannot back up these files because they are
relational. You have to back up relational databases on your own.
We have one more partition,
WrtB
, the writeback partition. It depends on a SQL Server
table
WrtB
. Writeback partitions are ROLAP partitions; therefore, Analysis Server can't back
them up, you must back up relational databases on your own.
So, when you are backing up an Analysis Services database, you should also consider
backing up following;
.
Server configuration file (
msmdsrv.ini
)
.
ROLAP partition and dimension data
.
Writeback data for supporting dimension and cell writeback
.
Query log table
.
Backup databases containing data for the remote partitions in case you have
designed a scaled-out solution
Analysis Services backup will back up the following:
.
Database metadata
.
Partition and dimension data files located in the data folder
.
Partition files located outside of the data folder in separate folders
Search WWH ::
Custom Search