The following file is corrupted: Physical file: <blah>Pretty much a server bit it pretty hard and after a manual reboot it came back up with a bunch of cubes having these corruption issues.
Sadly at this point all you can do is pray you have a decently recent backup to restore from however just working with the SSAS database is hard enough; if you try to do anything (detach, delete) it will just throw the corruption error.
Only way to handle this is to:
- Shutdown the SSAS service instance
- Find where the cube data directory is stored and delete all files related to the corrupted cubes
- Startup the SSAS service instance
- Restore from backup
- Pray
Hope you don't have to deal with this issue like I have.
No comments:
Post a Comment