Full Backup hangs.

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Full Backup hangs.

Postby Deepakh » Thu Mar 10, 2011 5:19 pm

We are currently using SQL backup5 and we have a full backup scheduled to run once a day for a particular database. We have been running this job without any hassles for a long time now. What should have taken 40-45 minutes is running for almost 30 hours and i do not see it completing. I did try stopping and restarting the sql backup agent service and it killed the job. I see a wait_type 'MSQL_XP' for the backup query.I checked the sql server error logs and i see the following errors when the backup is run



Log SQL Server (Current - XXXXXXX)

Source spid155

Message
BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_6XXXXXXA-XXXX1-XXXX-XXX6-XXXXX005'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

2)Back up failed. Check application logs.
3)BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_6XXXXXXA-XXXX1-XXXX-XXX6-XXXXX0'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request).

4)BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_6XXXXXXA-XXXX1-XXXX-XXX6-XXXXX02'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request)

Any pointers to solve this issue???
Deepakh
 
Posts: 1
Joined: Thu Mar 10, 2011 4:47 pm

Postby eddie davis » Mon Mar 14, 2011 2:54 pm

Thank you for your post into the forum.

A support call has been created for you, the call reference number is F0045554.

There can be many causes to the problem you have described. Are there any entries in the SQL Server Error logs and VDI logs that indicate a possible cause of the error?

From your post, I see that you have already stopped and restarted the SQL Backup Agent Service. On the next occasion the problem occurs can you please running the following query from a new query window in SSMS / Query Analyzer:
Code: Select all
execute master..sqbutility 9997


This function will provide a debugging trace of the current execution process in the SQL Backup engine.

Executing sqbutility 9997 will return a NULL value and generate a file in the named directory for the corresponding SQL Backup Agent (eg by default, C:\\Program files\\Red Gate\\SQL Backup\\%instance%, called "SQBCoreService_bugreport.txt")

Please send the resulting debug file to support@red-gate.com and include the above call reference number in the subject field on the e-mail.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests