How can we help you today? How can we help you today?

Differntial BU failing on SQL Backup 4.2.0.511

Using SQL Server 2000 - my differential backup job is failing occasionally. the output from the Event Viewer and SQL logs:
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_5F91D20C-1DBD-4A3A-80EE-C74178D04D41'. Operating system error 0x80070002(The system cannot find the file specified.).

BACKUP failed to complete the command BACKUP DATABASE [Source_Update] TO VIRTUAL_DEVICE = 'SQLBACKUP_5F91D20C-1DBD-4A3A-80EE-C74178D04D41' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (Source_Update), 1/4/2008 1:00:04 AM', DESCRIPTION = N'Backup on 1/4/2008 1:00:04 AM

BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_B0689C8B-357D-4A0A-A8F9-56C689077E8D'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Internal I/O request 0x75D7D7F0: Op: Write, pBuffer: 0x0E000000, Size: 65536, Position: 0, UMS: Internal: 0x1, InternalHigh: 0x75D7D8A8, Offset: 0x0, OffsetHigh: 0x62B31928, m_buf: 0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: SQLBACKUP_B0689C8B-357D-4A0A-A8F9-56C689077E8D

BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_B0689C8B-357D-4A0A-A8F9-56C689077E8D'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

BACKUP failed to complete the command BACKUP DATABASE [Source_Update] TO VIRTUAL_DEVICE = 'SQLBACKUP_B0689C8B-357D-4A0A-A8F9-56C689077E8D' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (Source_Update), 1/4/2008 1:00:04 AM', DESCRIPTION = N'Backup on 1/4/2008 1:00:04 am

Source spid144
Message
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_65FDC727-CCF7-48C0-950D-1484093B9404'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Source backup
Message
BACKUP failed to complete the command BACKUP DATABASE [Source_Update] TO VIRTUAL_DEVICE = 'SQLBACKUP_65FDC727-CCF7-48C0-950D-1484093B9404' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (Source_Update), 1/4/2008 12:30:01 AM', DESCRIPTION = N'Backup on 1/4/2008 12:30:01 AM

Source spid144
Message
BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_65FDC727-CCF7-48C0-950D-1484093B9404'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Source spid144
Message
Internal I/O request 0xB8AC57F0: Op: Write, pBuffer: 0x0DFD0000, Size: 65536, Position: 0, UMS: Internal: 0x730061, InternalHigh: 0xB8AC58A8, Offset: 0x0, OffsetHigh: 0xA04EB928, m_buf: 0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: SQLBACKUP_65FDC727-CCF7-48C0-950D-1484093B9404

I can't figure out why this fails. It failed at 12:30am but ran at 8:30am today. Any assistance will be greatly appreciated.
Thanks
geri
gsc_ghx
0

Comments

6 comments

Sort by
  • petey
    Could you please post the contents of the SQL Backup log file for the failed processes? The default folder where the logs are stored is in <system drive>:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
    petey
    0
  • gsc_ghx
    Peter - I am sorry but we don't havet that folder set up. So therefore there is no log file to send you.

    What next?
    Geri
    gsc_ghx
    0
  • petey
    You don't have to explicitly set it up. Assuming your system drive is C:\, is there a folder named C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\?

    Thanks.
    petey
    0
  • gsc_ghx
    Nope - no such folder on this system. At least on the active node of this cluster. I just checked my passive node - same thing - no folder under all users for Application Data and I have searched for the log on both machines.

    Geri
    gsc_ghx
    0
  • petey
    The log would have been useful in troubleshooting the issue further.

    Could you pls try creating that folder manually, then grant rights to the SQL Backup Agent service startup user, then run a test backup to see if a log is generated? Then the next time the differential backup fails, could you please send us the log for that failed backup?

    Thanks.
    petey
    0
  • gsc_ghx
    Peter - Thank you. I tried to create that folder - and discovered that we did have that folder. It was hidden and all the files in it were hidden. I have since found the log and discovered the reason that the backup failed. The file was in use - I believe there was a tape backup at that time and the backup process could not access the file.

    I do very much appreciate your help and responsiveness to my issue. Thanks

    Geri :D
    gsc_ghx
    0

Add comment

Please sign in to leave a comment.