Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 8:35 AM
Points: 6, Visits: 111
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Today @ 12:54 PM
Points: 1,822, Visits: 3,484
No. I haven't yet seen anyone successfully do this.


Steve.
Post #1596906
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse