Querying: Yes.
Processing: Yes, but they cannot commit the transaction. When you are
processing, the actual data is created in shadow files; then when you commit
the data is switched from the regular files and the shadow files. Commiting
implies that you take an exclusive lock out on the database, meaning that no
one can be querying or backing up or anything when the switch actually
occurs.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"chinn" <chinn (AT) discussions (DOT) microsoft.com> wrote
Quote:
Is archiving the olap or analysis services an online operation.What i mean
is
can
somebody access the cubes or processes when the archiving is going on
Thanks, |