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?

  • 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?

  • 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?

  • 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