Database Reference
In-Depth Information
keep your databases healthy, be very careful about having any extraneous
activity within the Analysis Services data folder.
There's more...
Any time you process an object (dimension, partition, cube, and so on), Analysis
Services creates a new "shadow" copy of the object and replaces the old object
with it upon completion of processing. This allows the database and all the under-
lying objects to remain available for queries during processing. Likewise, Analysis
Services creates shadow folders while restoring and synchronizing databases, so
you'll have to account for storage requirements necessary to perform such actions.
For example, if you have a 100 GB database and you want to restore it from a
backup—while the existing copy remains online—you need to have at least 200 GB
of total storage available on the drive, where you store the SSAS data.
Search WWH ::
Custom Search