Home Forums SQL Server 2005 Backups 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? RE: 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?