Analysis Services Backup
User Rating: / 1
PoorBest 
Written by Andrew Fryer   
Saturday, 23 August 2008 02:29

Backing up a cube is not an ideal experience in SQL Server 2005 for two reasons, it’s a manual process to schedule a backup and as the size of the cube grows the backup time increases exponentially i.e double the size of the cube and the backup time and size will increase by a factor of four.

Curiously although there is excellent management tools support for managing SQL Server as I mentioned yesterday, I am not aware of similar support for analysis services, despite the many third party tool vendors who make front ends for it. so here’s a few things to help..

Read more...
 

 

Pyramid Analytics