Cube file corrupted, cant restore backup

  • Hi guys, i am getting an error which looks like the cube file is corrupt.

    TITLE: Microsoft SQL Server Management Studio

    ADDITIONAL INFORMATION:

    File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TseboCube.0.db\Account Budget Import.0.dim\8190.(All).kstore. Logical file .

    Errors in the metadata manager. An error occurred when loading the Account Budget Import dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TseboCube.0.db\Account Budget Import.8190.dim.xml'.

    Errors in the metadata manager. An error occurred when loading the Budget Forecast cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TseboCube.0.db\Budget Forecast.16294.cub.xml'.

    (Microsoft.AnalysisServices)

    when I try to delete it snd restore from a back up, i get same error.

    Any idea how i can remove it and restore from back up?

    thanks guys

    Ian Cockcroft
    MCITP BI Specialist

  • I would re-deploy the cube from Visual Studio With Full Deploy and Process All Data.

    Thomas

    Thomas LeBlanc, MVP Data Platform Consultant

  • Did that solution work for you? If not, there are some extra steps you may need to do which are covered in this[/url] link.

  • Hi guys, thanks for the replies.

    I switched of the service. deleted the cub file and redeployed. worked.

    cheers

    Ian

    Ian Cockcroft
    MCITP BI Specialist

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

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