One of our clients gets the following error when trying to backup a database:
quote:System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during a read of page (1:1632) in database ID 4 at offset 0x00000000cc0000 in file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe 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. 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.
I tried to perform checkdb, checkdb repair_rebuild as well as checkdb REPAIR_ALLOW_DATA_LOSS but none of these corrected the issues is the MSDB database.
My question is: can I just grab a clean MSDB database from another instance to replace the corrupt one or do I really have to uninstall/reinstall SQL Server?
I can't connect remotely to the client's site right now but I'll try to post that CheckDB output later. Nevertheless, it seems irreparable. So my question remains: can I just grab a clean MSDB database from another instance to replace the corrupt one (i.e. is the MSDB generic for all instances or specific to each instance) or would it be best to just uninstall/reinstall SQL Server?