dbTalk Databases Forums  

Can i backup while processing is happening ?

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


Discuss Can i backup while processing is happening ? in the microsoft.public.sqlserver.olap forum.



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

Default Can i backup while processing is happening ? - 07-01-2005 , 12:33 PM






Can I backup Analysis Services database while processing is occuring or
process while backup is occuring ?

Also is there a way to just script out or backup just the schema for the
OLAP databases and not the data ?

Thanks



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Can i backup while processing is happening ? - 07-01-2005 , 01:09 PM






to backup the schema only one easy way is to copy your database into a new
one, this create an empty database with schema only. then backup this
version.

you can also backup only the repository database. but I have not tested this
for a restore action.

"Hassan" <fatima_ja (AT) hotmail (DOT) com> wrote

Quote:
Can I backup Analysis Services database while processing is occuring or
process while backup is occuring ?

Also is there a way to just script out or backup just the schema for the
OLAP databases and not the data ?

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.