Post reply

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?

  • June 17, 2009 at 10:36 am

    #201504

    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?

  • July 28, 2010 at 1:00 pm

    #1199466

    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?

  • July 29, 2010 at 11:30 pm

    #1200131

    You could always use good old Windows Task Scheduler with OSQL/SQLCMD.

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply