I backup my SSAS cubes called "BI LIVE" and restore it to a specific location on a different server.
I am using sql server 2014. This is where you can see the routine I use to run the backups:
How can I pass the server name as parameter for a XMLA script?
Another way to backup a SSAS Database can be found here:
How can I dynamically back up all SSAS databases on a given instance?
This is the script that I use to restore the backup of my SSAS database:
<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>H:\SSASBackup\BI LIVE_2015-09-16_210100.abf</File>
<DatabaseName>BI_Live_restored</DatabaseName>
<DbStorageLocation xmlns="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">F:\SSAS\</DbStorageLocation>
</Restore>
The restore completes, but it shows me the following error messages:
Executing the query ...
READS, 0 READ_KB, 0 WRITES, 0 WRITE_KB, 0 CPU_TIME_MS, 0 ROWS_SCANNED, 0
ROWS_RETURNED, 0
H:\SSASBackup\Boden BI LIVE_2015-09-16_210100.abf BI_Live_restored F:\SSAS\ Backup and restore errors: Backup storage file corruption: file not found. Possible cause of this error is corruption of backup file.
Execution complete
However, when I compare the LIVE cube with the RESTORED one, I get exactly the same results, the restored cube is fully operational, I have not found any errors within it, so far.
This is one of the MDX scripts that I am using so far to check the restored ssas database:
SELECT {
[Measures].[Units Sold]
,[Measures].[UK FSP]
} ON 0
,
{
[Order Date].[Trading Calendar].[Trading Week]
} ON 1
FROM BodenBI
WHERE [Order Date].[Trading Year].&[2015]
Both restored and live give me the same result:
I have been checking some links online, found this one:
How to Deal with Corruption in Analysis Services
How can I stop this error message?
How can I be sure my RESTORED cube is 100% good?
This can give some insights too:
How to check the health of a SSAS database? And of its backups?
