Cannot restore SQL Error Code:5133
I'm trying to restore a database and I get this output from the GUI:
TPFADBMOPS04\MIPFAPSQLFA01: Restore - Failed ============================================ Restoring full backup - Failed ------------------------------ This operation failed with errors. Restoring TPOCore_INTB (database) on MIPFAPSQLFA01 instance from: \\ppfainbaks01\SQLAdHocBackups\Mark\TPO\TPOCore_INTB.sqb SQL Server error SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally. SQL error 3119: SQL error 3119: Problems were identified while planning for the RESTORE statement. Previous messages provide details. SQL error 3156: SQL error 3156: File 'TPOCore' cannot be restored to 'D:\MSSQL.3\MSSQL\Data\TPOCore_INTB_TPOCore.mdf'. Use WITH MOVE to identify a valid location for the file. SQL error 5133: SQL error 5133: Directory lookup for the file "D:\MSSQL.3\MSSQL\Data\TPOCore_INTB_TPOCore.mdf" failed with the operating system error 5(error not found). SQL Backup exit code: 1100 SQL error code: 5133
Any ideas - i know that os system error 5 means Access Denied - what is access denied? The sql backup service account is a sysadmin in SQL Server and a local admin on the server.