none
Restoring Contoso Back file failed-Backup and restore errors: the file specified in Restore command is damaged or is not an AS backup file. RRS feed

  • Question

  • Hi

    I downloded and extracted Contoso file as explained in this link:

    https://www.microsoft.com/en-ca/download/details.aspx?id=18279

    but I kept receiving the following error:

    Backup and restore errors: File '...\ContosoDataSet\ContosoBIdemoABF\Contoso_Retail.abf' specified in Restore command is damaged or is not an AS backup file.
    The following system error occurred:  Access is denied.  (Microsoft SQL Server 2017 Analysis Services)

    What is the reason and what is the workaround?

    Thanks

    Saturday, April 13, 2019 12:50 AM

All replies

  • Hi BESTMBAMAN,

    Thanks for posting here.

    According to the error message above,  it is caused by the file storage path of the backup file. Based on this, you could put the file under C disk ( create a folder under the disk, then put it  under the folder) and see if it works.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, April 15, 2019 6:55 AM
    Moderator