SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Corrupt MSDB database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

WindChaser
Posting Yak Master

225 Posts

Posted - 06/03/2014 :  23:24:56  Show Profile  Reply with Quote
Hi folks,

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?

Thanks!!!

elliswhitei
Starting Member

6 Posts

Posted - 06/04/2014 :  06:02:04  Show Profile  Reply with Quote
I think the main reason of this error occurrence is corruption in the SQL database which needs to repair first . Well this happens before backup so you need to deal with any external software.
Go to Top of Page

prett
Posting Yak Master

USA
203 Posts

Posted - 06/04/2014 :  06:24:20  Show Profile  Visit prett's Homepage  Reply with Quote
Can you please share the output of DBCC CHECKDB?
Go to Top of Page

WindChaser
Posting Yak Master

225 Posts

Posted - 06/04/2014 :  09:56:39  Show Profile  Reply with Quote
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?
Go to Top of Page

prett
Posting Yak Master

USA
203 Posts

Posted - 06/04/2014 :  22:50:02  Show Profile  Visit prett's Homepage  Reply with Quote
I would suggest you to restore from backup. It is the best option to solve the problem.

As per your question concern, I hope someone will jump into this thread and help you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000