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

SQL DIFF backup failing at random occasions

msouphymsouphy Posts: 7
edited June 6, 2011 12:01PM in SQL Backup Previous Versions
Hey,

I have SQL Backup 6 configured to take full backups once a day, diff backups every 6 hours, and log backups every 2 hours.

This has been working correctly without any problem for several months now.

Now since two weeks, occasionally, the diff backup fails. Like once every two days or so, it's kinda random.

This is the error message:
6/06/2011 6:00:04: Backing up PanoArchives (differential database) on BTCLUDB instance to: 
6/06/2011 6:00:04:   M:\Backup\PanoArchives\PanoArchives_DIFF_20110606_060004.sqb

6/06/2011 6:00:05: BACKUP DATABASE [PanoArchives]  TO VIRTUAL_DEVICE = 'SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C0174107', VIRTUAL_DEVICE = 'SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C017410701' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 
 1048576, NAME = N'Database (PanoArchives), 6/06/2011 6:00:04', DESCRIPTION = N'Backup on 6/06/2011 6:00:04  Server: BTCLUDB\BTCLUDB  Database: PanoArchives', FORMAT, DIFFERENTIAL
 
6/06/2011 6:02:07: Thread 0 error: 
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
6/06/2011 6:02:07: 
6/06/2011 6:02:07: Thread 1 error: 
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
6/06/2011 6:02:07: 
6/06/2011 6:02:35: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
[b]6/06/2011 6:02:35: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C0174107:" 995(failed to retrieve text for this error. Reason: 15105).[/b]

In Windows Server 2008 Event Viewer I have this:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=5132. Thread=5532. Client. Instance=BTCLUDB. VD=Global\SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C0174107_SQLVDIMemoryName_0.

Some extra info:

- The database server is a windows 2008 cluster with shared disks
- The backup drive (M:) has 123 GB free space, which is plenty in comparison to the size of the database backups (a few gigs), so it isn't a space issue.

Anybody has any ideas what could be causing this ?

thanks

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Are you using version 6.5.0 of the SQL Backup server components? If so, could you please update the server components to 6.5.1? You can do this using the 'Check for updates' option in the SQL Backup GUI, to download the updated version of the GUI. After that, you should update the server components on each instance.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thanks for the reply.

    Using 6.5.0.73 at the moment.

    Will upgrade to 6.5.1

    I see in the release notes for 6.5.1:
    VDI timeout removed. This was causing some restore operations for larger databases to time out before completion.
    

    My problems occurs when taking backups, not restores.

    But maybe this will solve this too ?
  • Options
    peteypetey Posts: 2,358 New member
    But maybe this will solve this too ?
    Yes it will.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.