Error when doing a Push in Ops Console - Unable to restore database to [location] from the test backup in [location] due to The operating system returned the error '5(Access is denied)'... Use WITH MOVE to identify a valid location for the file

Version 1

    Details

     

    Full error text:
    Unable to restore database to [location] from the test backup in [location] due to The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'LDFFilePathandName.ldf'. File 'FileNameHere' cannot be restored to 'LDFFilePathandName.ldf'. Use WITH MOVE to identify a valid location for the file. Problems were identified while planning for the RESTORE statement. Previous messages provide details. RESTORE DATABASE is terminating abnormally..

    This error occurs when the path given to the Ops Console for the Data Location and Transaction Log Location do not match the path being used when SQL accesses the same location. 

     


    Resolution

     

    - Log into Ops Console as admin 
    - Go to Landscape > Database Server 
    - Select the Landscape
    - Click the Edit pencil for the specific tenant
    - Change the file path for Data Location and Transaction Log Location to match what is present in SQL when a manual restore is done.