OS
WindowsSoftware
AllError message
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:\...\DATABASE_Delta_T.bak.2010-08-20-03-00-00-000.ADD'. Operating system error 5(Access is denied.)[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:\...\DATABASE_master.bak.2012-10-12-21-00-00-000.ADD'. Operating system error 5(error not found).
Cause
This means that the SQL-server is unable to write the export to the temporarily folder.Solution
Choose as the temporarily folder in the backupset settings a directory where the SQL-server can write to.- Check of the Windows-authentication and SQ-authentication of this set are filled out correctly.
- Check of the temporarily directory exists.
- Try choosing a different directory like 'c:\backuptemp'.