File System Error after Restore

Hi Guys,

I have issues in restoring our Analysis Services database. Any help will be great.

I took backups of our production olap database and Unfortunately, I had to restore next day and it didn't worked out very well.

Restore process was successful but when I tried to Query database I was getting error - "File system error: The following error occurred while the \\ \F:\Program File( x86)\ Microsoft SQL Server\MSSQL.2\OLAP\Data\<Olap db name>.0.db\<Cube name>.0.cub\...........\4.fact.data' ...

My cubes have 4 partitions. I used SSMS to back and restore. Used compressed option only. Let me know if I need to put more information.

Thank you - Ashok

I tried to run restore again so I can copy message. I got error while running restore following. I will try to run again...

TITLE: Microsoft SQL Server Management Studio
------------------------------

The ddl2:MemberKeysUnique element at line 63, column 5183 (namespace http://schemas.microsoft.com/analysisservices/2003/engine/2) cannot appear under Load/ObjectDefinition/Dimension/Hierarchies/Hierarchy.
Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\ \G:\SQLServerData\MSSQL.2\OLAP\Data\Risk Reports Histroy.0.db\Credit Counterparty.1.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Accounting cube, from the file, '\\ \G:\SQLServerData\MSSQL.2\OLAP\Data\Risk Reports Histroy.0.db\Accounting.1.cub.xml'.
(Microsoft.AnalysisServices)

------------------------------
BUTTONS:

OK
------------------------------

I tried to run new backup in production to start new test but I get this error. I see there is backup file of 29G I think i didn't checked the compressed mode. Backup was not completed. I have lot of disk space. I will checked that linked it's blocked at my work but I have SP2 in procution.

TITLE: Microsoft SQL Server Management Studio
------------------------------

File system error: The following error occurred while the '\\ \F:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\Risk Reports History.0.db\Positions.0.cub\Positions.0.det\Positions 2006.0.prt\14.fact.data' file was being copied to the 'F:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Backup\Risk Reports History.abf' file: .
(Microsoft.AnalysisServices)

------------------------------
BUTTONS:

OK
------------------------------

Ashok, I am having this same problem.

I process the cube on one server, can browse the data fine, but when I backup and restore to the other server, get the file corrupt error, see below.

I have tried to clean out the data directory, tried restoring the backup from both local and network share locations. Same result each time. One note is that this project was first created by using a solution, then adding projects, but one developer opened the project by creating it from server inside of bids...so I ended up with solution files are more than one folder depth. I read one entry that said this might have caused the problem.

Error when browsing cube on target production server after restore from development server backup.

Any luck fixing it

any help would be greatly appreciated.

Troy