backup job failed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

backup job failed

Author

Topic

DBA007
Posting Yak Master

145 Posts

Posted - 2010-02-09 : 10:46:52

Team,
My backup job was executing continuously as I found in the error log as
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_F2381D64-154C-4F22-8B67-ED444941C3AF02'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

iam not able to get the solution for this error.

Kristen
Test

22859 Posts

Posted - 2010-02-09 : 11:06:32

Is this some third party SQL backup direct to tape? (rather than SQL Server's own inbuilt BACKUP command)?

DBA007
Posting Yak Master

145 Posts

Posted - 2010-02-09 : 11:13:37

no,this is a inbuilt backup command which is used in the job, happening to share folder

Kristen
Test

22859 Posts

Posted - 2010-02-09 : 11:17:03

OK, sorry don't know the answer then.

Can you (manually) BACKUP to another location successfully?

Can you run a test on the disk? (on the machine with the share that you are trying to backup to)

Anything in the EVENT log? (on the machine with the share that you are trying to backup to)

DBA007
Posting Yak Master

145 Posts

Posted - 2010-02-09 : 11:32:48

I can manually do the backup to the share location,and there was nothing in the event log.as the backup job has backedup some databases to the location and it started running continuously with the error as 995

DBA007
Posting Yak Master

145 Posts

Posted - 2010-02-10 : 12:31:42

write failure on backup device 'SQLBACKUP_F2381D64-154C-4F22-8B67-ED444941C3AF'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.)

I didnt find any thing except this?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-02-10 : 13:26:05

What's the exact command that you're running to do that backup?

--
Gail Shaw
SQL Server MVP

DBA007
Posting Yak Master

145 Posts

Posted - 2010-02-10 : 13:51:50

This is the code

DECLARE @out int
DECLARE @sqlerror int
exec master..sqlbackup '-SQL "BACKUP DATABASES EXCLUDE [tempdb] TO DISK = ''\\sqlbackup\g$\mybackup\<AUTO>'' WITH ERASEFILES_ATSTART = 1, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, FILECOUNT = 3, INIT, KEYSIZE = 256, NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>''"', @out OUTPUT, @sqlerror OUTPUT
IF (@out <>0) OR (@sqlerror <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with out: %d SQL error: %d', 16, 1, @out, @sqlerror)
END

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-02-11 : 03:32:08

That is not a SQL Native backup.

Might be RedGate's SQL Backup tool. Find the log that the 3rd party tool writes and check that for errors.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources