SQL backup fails with "Cannot open backup device "DBNAME". Operating system error 0x80070002 (The system cannot find the file specified.)

Article:TECH64648  |  Created: 2008-01-30  |  Updated: 2014-05-14  |  Article URL http://www.symantec.com/docs/TECH64648
Article Type
Technical Solution


Issue



SQL backup fails with "Cannot open backup device "DBNAME". Operating system error 0x80070002 (The system cannot find the file specified.)


Error



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



1. Download and install the hotfixes from Microsoft KB Article 934396.
 
FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000 http://support.microsoft.com/kb/934396
 
2. Backup Exec Service Account should have full Administrator rights & permission on SQL databases.

Supplemental Materials

SourceUMI
ValueV-79-65323-3201
Description

Cannot open backup device "DBNAME".


SourceError Code
Value0x80070002
Description

The system cannot find the file specified.



Legacy ID



313264


Article URL http://www.symantec.com/docs/TECH64648


Terms of use for this information are found in Legal Notices