valeris Posted October 1, 2008 Report Share Posted October 1, 2008 Hello, Could someone explain how to fix the following error: - 10/1/2008 10:53:54 AM: Copying DB_TABLE on DB_SERVER Backup type: Full Trouble reading files, error -3840 (The operation terminated abnormally.) 10/1/2008 10:56:18 AM: Execution incomplete Remaining: 1 files, 42.9 GB Completed: 0 files, zero KB Performance: 0.0 MB/minute Duration: 00:02:24 (00:00:16 idle/loading/preparing) Quote Link to comment Share on other sites More sharing options...
Mayoff Posted October 1, 2008 Report Share Posted October 1, 2008 This error is coming directly from the SQL Server. What do your SQL logs and Windows event logs show for this backup attempt? Does it happen with every backup attempt? Are you able to backup the database with the built in SQL backup tool? Does it fail too? Quote Link to comment Share on other sites More sharing options...
valeris Posted October 1, 2008 Author Report Share Posted October 1, 2008 I have found following MSSQL errors in Application part of system eventlog: EventID : 17055 3041 : BACKUP failed to complete the command BACKUP DATABASE [TMESCOPE] TO VIRTUAL_DEVICE='dantz_retrospect_vd_TableName' WITH INIT 18210 : BackupVirtualDeviceSet::Initialize: Open failure on backup device 'dantz_retrospect_vd_TableName'. Operating system error 0x80070002(The system cannot find the file specified.). MSSQL has errors with the same description as above. I gave these errors for all tables at this server for each backup attrmpt. Quote Link to comment Share on other sites More sharing options...
Mayoff Posted October 1, 2008 Report Share Posted October 1, 2008 The error reported by Microsoft is the 0x80070002 error. You should be able to google that error. Retrospect sends a backup command to SQL. SQL copies the backup to a virtual device and Retrospect reads the virtual device. It sounds like your server is having a VDI failure. Google 0x80070002 and the event ID's reported my Microsoft. http://www.google.com/search?hl=en&client=safari&rls=en-us&q=sql+0x80070002&btnG=Search Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.