Currently I have my repository in SQL Server and also my data folder backed
up every 12 hours.

How would I propery restore both of these objects? Say I have to start out
with a clean version of AS, how would I restore from the repository and data
file?

Is it as simple as changing the repository string and the location of the
data folder? In what order?

The best thing to do is archive all your OLAP databases on that server. This
creates CAB files for each database wherever you tell it to do the archive.
Then, just restore those databases from those cab files onto your server
after you reinstall AS, or do whatever it is you need to do.

The good thing about an archive/restore is that it brings your OLAP data and
your repository information with it, you don't need to worry about anything.
If your data fits within the abilities of archive/restore, definitely use
archive/restore.


Good luck.


"Jesse O" wrote:

Thanks for the reply.

However, our OLAP db's are too large to do an archive...we'll have to file
copy the data folder.


"SQL McOLAP" <SQLMcOLAP (AT) discussions (DOT) microsoft.com> wrote

Yes, if any cubes have partitions that are too large, you can't use
archive/restore, unfortunately. In this case, you need to backup your SQL
repository and backup your entire data folder. Then, these two things would
need to be restored. On the plus side, this is faster than archive and
restore.

One thing you may want to consider is partitioning if possible. If your
partitioning grain results in partitions that are small enough to fit into
CAB files, then you can use archive/restore, another benefit of partitioning,
although the bigger benefits of partitioning are faster processing because of
parallelism and better query response time if partitioned by commonly queried
slices.

Just something for you to ponder...good luck.

"Jesse O" wrote: