How can I remove a corrupted SSAS database?

_{Tuesday, January 18, 2011 12:38 PM}

I was trying to update an SSAS database on a test server and got the following error when trying to deploy from Visual Stuido.  I get a similar error in SMS.  I tried to delete the database before deploying but I get an error when trying to delete.  I rebooted the server.

(SQL Server 2005 R2, Windows Server 2008R2.)

Error 1 File system error: The following file is corrupted: Physical file: \?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Heidtman Sales Cube.0.db\Dim Age.0.dim\5.Dim Age.Dim Age.dstore. Logical file . Errors in the metadata manager. An error occurred when loading the Age dimension, from the file, '\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Heidtman Sales Cube.0.db\Dim Age.5.dim.xml'. Errors in the metadata manager. An error occurred when loading the Heidtman DW cube, from the file, '\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Heidtman Sales Cube.0.db\Heidtman DW.7.cub.xml'.   0 0 

_{Tuesday, January 18, 2011 1:29 PM ✅Answered | 5 votes}

99% of the time unprocessing it (then reprocessing it) or deleting it works. So that's odd it didn't work for you.

I suppose you could stop SSAS, go into the Data directory, find the <CubeID>.<VersionNum>.db.xml file and delete it, and delete the corresponding <CubeID><VersionNum>.db directory. Then when you restart SSAS, it should be gone, and you can hopefully redeploy and reprocess it. But everything I just explained in this paragraph is probably very much unsupported (though it worked for me).

If that's the only SSAS database deployed to that instance, then you can just stop SSAS, delete all the files and subdirectories of the Data directory, then restart SSAS. SSAS will then recreate all the "default" files it needs and you'll have an "empty" instance. Make sure to you're a server admin first, and make sure to readd all the SSAS admins so they have permissions like they did before.

http://artisconsulting.com/Blogs/GregGalloway

_{Tuesday, January 18, 2011 1:49 PM}

That seemed to do the trick...it was the only cube on the sever so I just killed the data folder.  I was going to try that but wasn't sure what all I could delete...THANKS!

_{Wednesday, October 14, 2015 8:57 AM}

Thanks Greg,

You just saved a life.

me

_{Friday, May 6, 2016 9:07 PM}

You saved my life too. A million thanks to you Buddy!

Merin