Back up analysis services database

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Back up analysis services database

Postby jacw2000 » Mon Jul 09, 2012 1:51 pm

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
jacw2000
 
Posts: 3
Joined: Wed Feb 01, 2012 11:28 am

Postby james.billings » Tue Jul 10, 2012 2:42 pm

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
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby jacw2000 » Tue Jul 10, 2012 3:08 pm

Thanks James
Something for Version 8 perhaps? :)
Regards
Jack
jacw2000
 
Posts: 3
Joined: Wed Feb 01, 2012 11:28 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests