0

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:

enter image description here

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?

  • Wonder if you need to add the XML "AllowOverwrite" element to overwrite the existing cube? I wouldn't think it'd matter, but I see the .abf file name has spaces but wonder what'd happen if you took out spaces of the file name itself of the backup file and try to restore without the spaces in that file name. Article that shows this XML element and the examples I see of this online never have spaces in the abf file name if that even matters. Something simple to test at least to eliminate as cause: mssqltips.com/sqlservertip/1906/… – Pimp Juice IT Sep 21 '15 at 23:16
  • 1
    What's the output if you verify the backup using the command I gave you in the other question? – Tom V - try topanswers.xyz Oct 5 '15 at 11:34
  • @TomV I am not ignoring you, I will reply as soon as I can – Marcello Miorelli Oct 6 '15 at 16:05
  • Have you verified the server you are restoring to is the exact same SSAS version and patch level? Also make sure the SSAS service account has access to the .abf file. – GregGalloway Nov 2 '15 at 6:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.