CODEWITHSUNDEEP
sql-server-2008sql-server-2005
Joe
Joe

Reputation: 55

Scheduled job failure

I have a schedule job to take backup for every 8 hours in SQL Server 2008. Till day before yesterday everything was working fine but all of sudden the job got failed with the error message below.

Executed as user: NT AUTHORITY\SYSTEM. A nonrecoverable I/O error occurred on file "FilePath\FileName.BAK:" 112(failed to retrieve text for this error. Reason: 15105). [SQLSTATE 42000] (Error 3271) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

I tried searching in google bout didn't get the exact idea. Consider me a newbee in SQL Server 2008

Any suggestions will be higly appriciated.

Thanks.

Upvotes: 0

Views: 5399

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300549

The most common reason for this error is lack of space to perform the backup.

Other reasons are a corrupt database or hardware problems.

Suggest you run DBCC CHECKDB as soon as you can.

Upvotes: 2

Related Questions