BACKUP JOB in maintenace plan failed

Question

Post reply

BACKUP JOB in maintenace plan failed

shanila_minnu

Hall of Fame

Points: 3465
More actions
September 19, 2011 at 11:45 pm

#243419

when i try querying sp_helpdb in particular databse its giving the error
=====================================================
The operating system returned error 1(error not found) to SQL Server during a read at offset 0x00000000460000 in file 'D:\MSSQL.1\MSSQL\DATA\ATX_MBDM.mdf:MSSQL_DBCC29'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I performed a DBCC CHECKDB..but i got the same error with 0 errors returned...i checked suspect_pages table in msdb database,No entries are there
Below is the log file for the job
======================
Started: 12:05:07 AM
Error: 2011-09-20 00:27:12.11
Code: 0xC002F210
Source: Back Up Database Task Execute SQL Task
Description: Executing the query "BACKUP DATABASE [ATX_MBDM] TO DISK = N'\\au\isdata\Backup\CHRIS21_Backup\AUMELBVEYAPDB01_Backup\\ATX_MBDM_backup_201109200005.bak' WITH NOFORMAT, NOINIT, NAME = N'ATX_MBDM_backup_20110920000512', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "A nonrecoverable I/O error occurred on file "D:\MSSQL.1[highlight=#ffff11]\MSSQL\DATA\ATX_MBDM.mdf:" 1(error not found).
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.[/highlight]End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:05:07 AM
Finished: 12:28:28 AM
Elapsed: 1401.13 seconds

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

A few suggestions:

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/422c9841-6eb7-42ca-ab5d-50db52bbaa7a/

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

jshailendra SSCrazy Points: 2260 More actions · Answer 2

Is this the maintenance plan for performing backup? If it is, check maintenance plan history it may give you more informational error message. Did you checked the event log and sql server log for the time when your job failed?

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 3

Is this is production database ? have there been any restarts?

Jayanth Kurup[/url]

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 4

its a production server...haven't restarted for the bast 2 to 3 months..also i am unable to check the sql error log..its showing the same error

Alan-314321 Default port Points: 1439 More actions · Answer 5

Go to the error log directory and check error log using a text editor.

Alan

R_S Ten Centuries Points: 1160 More actions · Answer 6

Try taking the backup on the local drive rather than network path and see if it is a issue with the database or the network