Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CommVault Backup errors on SQL 2000 Expand / Collapse
Author
Message
Posted Saturday, September 22, 2012 1:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #1363078
Posted Wednesday, September 26, 2012 12:45 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 14, 2014 8:21 AM
Points: 3,084, Visits: 1,433
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
Post #1364890
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse