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:36 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 #736791
Posted Wednesday, July 28, 2010 1:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 2:09 PM
Points: 5, Visits: 556
by now you might already have a plan in place but we use Control-M scheduler to fire a Tivoli Storage Manager backup job passing to it a bat file that contains the SQL Server backup command and targeted files. we used to use SQL Agent but thinking you could still use SQL Agent to fire a backup procedure and target the path to the SSAS cubes' Backup Directory as designated in the SSAS instance Properties?
Post #960316
Posted Thursday, July 29, 2010 11:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 20, 2014 9:06 PM
Points: 2,693, Visits: 1,202
You could always use good old Windows Task Scheduler with OSQL/SQLCMD.



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #961137
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse