Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Backing up / Restoreing cubes from Files Expand / Collapse
Posted Monday, July 28, 2014 7:15 AM


Group: General Forum Members
Last Login: Wednesday, July 15, 2015 8:33 AM
Points: 11, Visits: 155
Not sure if this is the right place

We have all incremental backups of all the files in the OLAP\data folder, and we had the cube become corrupt

we dont have a backup of the cube (yes i know) but we do have the latest version of the files in the data folder

I have tried restoring the data folder, and then attaching the cube but i get
The database cannot be attached because an error occurred while loading the detach log from the file '\\?\G:\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\GMDD.0.db\ABC.detach_log'. One possible reason is that database is already attached in ReadWrite mode to another server instance.
The detach log '\\?\G:\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\ABC.0.db\ABC.detach_log' could not be found in the specified database folder.
Execution complete

Is it possible to do this type of a restore. i.e. can it be rebuilt this way ?
Post #1596847
Posted Monday, July 28, 2014 8:58 AM



Group: Moderators
Last Login: Saturday, November 5, 2016 7:09 PM
Points: 1,896, Visits: 3,753
No. I haven't yet seen anyone successfully do this.

Post #1596906
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse