Post reply

Unable attach analsysis service database without detach log file

  • October 14, 2011 at 1:12 am

    #146366

    Hi

    Post recycle of Analysis Service we found one of the database went missing. So we tried attaching it. But its failing with below error:

    [highlight=#ffff11]The detach log '\\?\E:\SalesCube_Monthly.0.db\SalesCube_Monthly.detach_log' could not be found in the specified database folder.

    The database cannot be attached because an error occurred while loading the detach log from the file '\\?\E:\SalesCube_Monthly.0.db\SalesCube_Monthly.detach_log'. One possible reason is that database is already attached in ReadWrite mode to another server instance.[/highlight]

    We did not detach the file, so we this file detach_log did not get created. Is there any other way, we can attach this database ?

  • April 10, 2013 at 11:45 am

    #1605354

    Hi,

    Any resolution to this? I am facing the exact same issue today.

  • April 10, 2013 at 8:48 pm

    #1605453

    Nope. We restored cube from the backup 🙁

  • April 8, 2014 at 11:33 pm

    #1704372

    I get the same issue - all Analysis Databases disappeared after a reboot. It would be great if there was a way to attach the databases without detach_log, as there are no backups.

    If anyone is aware of a workaround, please share it here. Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

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