Error on Analysis services Database loading

Hi, all experts here,

Thanks a lot for your kind attention.

Please could any of you here help me to have a look at the following error when I deployed the analysis services databases to the analysis services server. It always got the problem as below, why is that? And what could I try to fix it?

Error 1 File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Geography.0.dim\5.Postal Code.Postal Code.dstore. Logical file . Errors in the metadata manager. An error occurred when loading the Geography dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Geography.5.dim.xml'. Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.28.cub.xml'. Errors in the metadata manager. An error occurred when loading the Customer Clusters ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Customer Clusters ~MC.7.cub.xml'.

Thanks a lot in advance for your advices and help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Can you try stop the service (net stop mssqlserverolapservice) and then delete the Adventure Works DW.0.db folder and Adventure*.xml file then restart your service.. Then redeploy adventure works dw database.

|||

Hi, Chu Xu,

Thanks a lot for your advices. It worked.

With best regards,

Yours sincerely,