Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup job failed Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 2:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:20 AM
Points: 273, Visits: 991
Hi,

We have a maintance job for backup which failed with below error.


NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.5069
Report was generated on "xxx".
Maintenance Plan: EDS
Duration: 00:41:42
Status: Warning: One or more tasks failed..
Details:
Back Up Database Task (xxx)
Backup Database on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All databases
Type: Full
Append existing
Task start: 2013-06-09T22:01:17.
Task end: 2013-06-09T22:40:08.
Failed-1073548784) Executing the query "BACKUP DATABASE [xxx] TO DISK = N'D:\\MSSQL.1\\MSSQL\\Backup\\xxx_xxxx_xxx.bak' WITH NOFORMAT, NOINIT, NAME = N'xxx_xxxx_xxx17', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "D:\\MSSQL.1\\MSSQL\\Backup\\xxx_xxxx_xxx.bak" failed: 112(error not found)
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.



can any one help me to find out the exact issue.

Many THanks,

Post #1471483
Posted Tuesday, July 9, 2013 3:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:38 AM
Points: 223, Visits: 1,725
What have you checked?
Because this "112(error not found)" =There is not enough space on the disk.
http://www.mssqlforum.com/threads/a-list-of-operating-system-errors.26/
Post #1471507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse