SQL backup fails with "Cannot open backup device "DBNAME". Operating system error 0x80070002 (The system cannot find the file specified.)
Problem
SQL backup fails with "Cannot open backup device "DBNAME". Operating system error 0x80070002 (The system cannot find the file specified.)
Error Message
Cannot open backup device "DBNAME". Operating system error 0x80070002 (The system cannot find the file specified.) / V-79-65323-3201 - Cannot open backup device 'LUBA_00__e8ac25bc_dccd_4025_8c76_230806fb2fbc_'. Operating system error 0x80070005(Access is denied.).
SQLVDI errors show in the Application Event Log
RAWS (Remote Agent for Windows Servers) DEBUG shows:
3391 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error GUID: 9cbfe10
3392 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error Source: Microsoft OLE DB Provider for SQL Server
3393 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error Description: DATABASE is terminating abnormally.
3394 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error State: 42000
3395 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error Number: 3013
3396 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error GUID: 9cbfe10
3397 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error Source: Microsoft OLE DB Provider for SQL Server
3398 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error Description: Cannot open backup device 'DATABASENAME'. Operating system error 0x80070002(The system cannot find the file specified.).
3399 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error State: 42000
3400 BEREMOTE: [10/29/08 10:46:00] [1056] SQL Error Number: 3201
Solution