What are the challenges you face when working across database platforms? Take the survey
Options

Back up analysis services database

jacw2000jacw2000 Posts: 4
edited July 10, 2012 10:08AM in SQL Backup Previous Versions
I regularly use Red Gate for database backups. Now I'm getting involved in Analysis Services (SSAS) and I want to back up the database(s) created in SSAS. I don't think that SQL Backup can do this, but please prove me wrong. Is there another tool which can?

Thanks in advance
Regards
Jack

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    Thanks for your post.

    Unfortunately SQL Backup only works with your system & user databases and won't work with Analysis services ones (as you suspected).

    I'm not aware of a 3rd party tool off the top of my head that would help, but a quick google led to some useful looking information here
    Systems Software Engineer

    Redgate Software

  • Options
    Thanks James
    Something for Version 8 perhaps? :)
    Regards
    Jack
Sign In or Register to comment.