September 19, 2011 at 11:45 pm
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
September 20, 2011 at 12:19 am
A few suggestions:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 20, 2011 at 12:37 am
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?
September 20, 2011 at 12:50 am
September 20, 2011 at 2:38 am
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
September 21, 2011 at 8:44 pm
Go to the error log directory and check error log using a text editor.
Alan
September 22, 2011 at 1:31 pm
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply