What are the challenges you face when working across database platforms? Take the survey
Options

Differntial BU failing on SQL Backup 4.2.0.511

gsc_ghxgsc_ghx Posts: 73
edited January 8, 2008 9:28AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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>.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
Sign In or Register to comment.