March 22, 2013 at 8:30 am
Hi,
I have a backup task that isnt working, it used to but a couple of days ago stopped. I created a new version of the task and it has also reported a failure. All of the bak files have been created by the task and I can recover from them. I therefore have no idea why it is reporting a failure.
Please see the notes below, not much to go on I know, they are usually more helpful than this:
Date22/03/2013 12:57:06
LogJob History (Non-ODM Backups.Backup Databases)
Step ID1
ServerSQL
Job NameNon-ODM Backups.Backup Databases
Step NameBackup Databases
Duration00:37:42
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: NEFTEXOIL\SQLAgent. :30:02.41 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [Team] TO DISK = N'K:\SQL_Backups..." failed with the following error: "A nonrecoverable I/O error occurred on file "K:\SQL_Backups\Team_Backups\Team_backup_2013_03_22_125713_7338597.bak:" 112(failed to retrieve text for this error. Reason: 15100). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Progress: 2013-03-22 13:34:34.23 Source: Back Up Database Task Executing query "BACKUP DATABASE [Team_Archive] TO DISK = N'K:\SQL...".: 50% complete End Progress Progress: 2013-03-22 13:34:46.19 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Error: 2013-03-22 13:34:46.71 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [webmap] TO DISK = N'K:\SQL_Backu..." failed with the following error: "A nonrecoverable I/O error occurred on file "K:\SQL_Backups\Team_Backups\webmap_backup_2013_03_22_125713_7418605.bak:" 112(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:57:07 Finished: 13:34:47 Elapsed: 2260.64 seconds. The package execution failed. The step failed.
Many Thanks for your help,
Oliver
March 22, 2013 at 8:38 am
I think that the error 112 is when you run out of disk space. Are the databases that failed too large to fit on your K: drive? I would definitely start here and hopefully you have a SAN where you can get more space allocated.
If this is being driven by a maintenance plan that also deleted old backups, keep in mind that the backup occurs first, then the old one is deleted. This means that if you keep 2 days worth of backups, you need 3 times the space of a single backup space on the disk. The current backup set will complete (so 3 are present) then the oldest set is deleted, leaving only 2 days.
March 22, 2013 at 8:41 am
Are these native backups? What edition of SQL Server are you running? Are you using, if available, compressed backups? Where are you backing up your databases, local, SAN, NAS?
March 22, 2013 at 8:45 am
I think it must be a disk space issue. The cleanup wizard wasnt picking up and removing the old bak and trn files from the system. Its amazing how fast a 2TB drive fills up these days.
Many Thanks for your help,
Oliver
March 22, 2013 at 10:05 am
error 112 is definitely a space issue.
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply