dbTalk Databases Forums  

backing up OLAP database question

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


Discuss backing up OLAP database question in the microsoft.public.sqlserver.olap forum.



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

Default backing up OLAP database question - 06-08-2004 , 04:58 AM






Hi Experts!

I found some information about backing up OLAP databases from Analysis with
the msmdarch utility. After succesfully backing up a database I found that
the utility saved the backup as a CAB file, in fact a compressed archive.

The machine on wich the Analysis Services runs is automaticaly backed up
every night. Is it nessesary to use the msmdarch utility? When I need to
restore a database, isn't it possible to place back the OLAP data dir?

Regards,

Rob



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

Default Re: backing up OLAP database question - 06-08-2004 , 10:24 AM






http://www.microsoft.com/technet/pro.../anservog.mspx
Might be helpful here.
--
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.

"Rob" <legedoos__ANTISPAM__ (AT) hotmail (DOT) com> wrote

Quote:
Hi Experts!

I found some information about backing up OLAP databases from Analysis
with
the msmdarch utility. After succesfully backing up a database I found that
the utility saved the backup as a CAB file, in fact a compressed archive.

The machine on wich the Analysis Services runs is automaticaly backed up
every night. Is it nessesary to use the msmdarch utility? When I need to
restore a database, isn't it possible to place back the OLAP data dir?

Regards,

Rob





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.