Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is the best method of backing up SSAS 2008 databases and cubes on a server where SQL server is not installed and we just have SSAS installed? Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 10:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 11, 2013 4:51 AM
Points: 12, Visits: 43
What is the best method of backing up SSAS 2008 databases and cubes on a server where SQL server is not installed and we just have SSAS installed?
Post #736787
Posted Wednesday, June 17, 2009 11:38 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Sunday, April 13, 2014 11:43 PM
Points: 1,781, Visits: 3,340
*Other* than the built in SSAS backup mechanism?? You don't need MSSQL to backup an SSAS cube, in 08 (and 05 and to a lesser extent 2k) you can backup from within SSAS to an *.abf file. This can have compresion turned on and also be password protected.

If you want to schedule/automate this, and you don't have SQL Agent to do the timings, if you do have (say) cron or any other scheduler, you should be able to run XMLA against the SSAS instance to get the back up to run (ie script the execution of the backup).



Steve.
Post #736838
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse