Post reply

SSAS backup failure "Possible cause for that is missing or corrupt cryptokey.bin or detach.log file."

  • February 25, 2013 at 9:56 pm

    #270995

    Recently migrated from 2008 to 2012. Everything is working fine; however went to take my first set of backups today and one of them blew up:

    Executing the query ...

    Backup and restore errors: Unexpected number of disk files associated with database object. Possible cause for that is missing or corrupt cryptokey.bin or detach.log file.

    Execution complete

    Anyone seen this before? Not finding much online on the specific error.

    - Data source is valid

    - Can process the cube

    - Can query / navigate cube

    Next step would be drop/recreate; however this is an older cube that I'd prefer to leave alone at this stage if possible.

    Any help would be appreciated.

    Thanks

  • March 27, 2015 at 10:06 am

    #1786966

    I ran into the same error after migrating Analysis Services from 2012 to 2014 and since this is the only post about it online, I figured I would share my experience. Adam was correct that simply scripting out the database, dropping it, and then recreating it would resolve the issue of backups throwing the error:

    Backup and restore errors: Unexpected number of disk files associated with database object. Possible cause for that is missing or corrupt cryptokey.bin or detach.log file.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply