dbTalk Databases Forums  

Archiving OLAP Database in Sql 2k

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Archiving OLAP Database in Sql 2k in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chinn
 
Posts: n/a

Default Archiving OLAP Database in Sql 2k - 12-01-2004 , 11:33 AM






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,

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Archiving OLAP Database in Sql 2k - 12-01-2004 , 04:45 PM






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,



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.