|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Saturday, September 22, 2012 1:06 AM
Points: 1,
Visits: 1
|
|
i am getting the belwo event on windows event:
Event in Windows:
Error: 823, Severity: 24, State: 2 I/O error (torn page) detected during read at offset 0x000000024ee000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf'.
i am receiving the below erro form camvault backup job : Failure Reason: • ERROR CODE [30:325]: Error encountered during backup. Error: [I/O error (torn page) detected during read at offset 0x000000024ee000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf'. Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful. Processed 4800 pages for database 'msdb', file 'MSDBData' on file 1. Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1. BACKUP DATABASE successfully processed 4801 pages in 0.969 seconds (40.580 MB/sec). The statement has been terminated. An exception occurred while executing a Transact-SQL statement or batch.]
kindly advise.
ZAHOOR
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 3,051,
Visits: 1,358
|
|
zahoorr (9/22/2012) i am getting the belwo event on windows event:
Event in Windows:
Error: 823, Severity: 24, State: 2 I/O error (torn page) detected during read at offset 0x000000024ee000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf'.
i am receiving the below erro form camvault backup job : Failure Reason: • ERROR CODE [30:325]: Error encountered during backup. Error: [I/O error (torn page) detected during read at offset 0x000000024ee000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf'. Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful. Processed 4800 pages for database 'msdb', file 'MSDBData' on file 1. Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1. BACKUP DATABASE successfully processed 4801 pages in 0.969 seconds (40.580 MB/sec). The statement has been terminated. An exception occurred while executing a Transact-SQL statement or batch.]
kindly advise.
ZAHOOR Try running DBCC Checkdb on the MSDB database. Your MSDB may be corrupt!
 My blog
|
|
|
|