How to Deal with Corruption in Analysis Services

re: How to Deal with Corruption in Analysis Services

Karan Gulati (SSAS Maestro) — Fri, 25 May 2012 10:05:55 GMT

That could happen if somehow your master.vmp file doesnt have entry for associated database.

blogs.msdn.com/.../tampering-master-vmp-file-may-result-in-losing-all-analysis-services-databases.aspx

Regd - Logs - unfortuantely there is no mechanism of tracking corruption

What i can advise you is to go - connect.microsoft.com and give your feedback regd. this to our Product team.

re: How to Deal with Corruption in Analysis Services

Srinivas — Fri, 25 May 2012 09:20:22 GMT

That’s quite useful, thanks for the information.

I have come across with a scenario where I don’t see my Cube DB at all and I was in an impression that it might have been dropped by someone but I also learnt that, “A database can be dropped by SSAS at start up in case of cube corruption”. I am curious to understand is there anyway I can track or check in Logs that Cube got dropped by SSAS.

Please Help !!!