I'm trying to restore a database and I get this output from the GUI:
- Code: Select all
TPFADBMOPS04\\MIPFAPSQLFA01: Restore - Failed
Restoring full backup - Failed
This operation failed with errors.
Restoring TPOCore_INTB (database) on MIPFAPSQLFA01 instance from:
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.