RE: why inconsistency errors on msdb again?

From: bing (bing_at_discussions.microsoft.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 12:31:06 -0700

"Vikram Jayaram [MS]" wrote:
>
> The db was restored to the same "clean" hardware and checkdb reported
> clean. And after that, you saw errors on msdb.
>

Yup, that's what happened here.
 
> Questions -
> 1. Is this just the msdb database? Or are other db;'s also showing
> consistency errors?

Yes, just the msdb database. Other databases are fine. Would this mean OS
or hardware problems are most unlikely?

> 2. Could it be that there's a hardware issue that's causing recurring
> corruption? You might want to check out
> 826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
> http://support.microsoft.com/?id=826433
>
That's what I suspected. But I'm not able to find more evidences to confirm
that. Have you ever seen or known that any inappropriate database operations
could cause such kind of recurring inconsistency errors? As far as I know,
our SQL 2000 server is not heavily loaded. 826433 PRB has too much
information for me to understand right away. The article mentions 'disabling
read cache'. If that could help solve the I/O problem, would that cause any
negative impact on the SQL server?

Thanks,

Bing

Relevant Pages

  • Re: msdb database marked as "suspect"
    ... Search Google and KB for suitable phrases such as "rebuild" and "msdb", ... you run instmsdb.sql to get a new fresh msdb database. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Database is not starting up
    ... I was trying to move the MSDB and Model datafiles from one ... To move the MSDB database on SQL Server 2000, ... Stop and then restart SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: sql dont start after detach model and msdb
    ... detach the model and the msdb database at the same time (with trace flag ... service wont start anymore!!! ... knowledgebase article 224071, I does also with msdb, but then I though about ... safeing time and detach msdb and model in the same time. ...
    (microsoft.public.sqlserver.server)
  • Re: Please Help : SQLServerAgent cannot start
    ... Could you please check whethere the UserAccess for MSDB is set to ... > We got power failure at last midnight, ... I can see and access the MSDB database, ... > reboot after power failure. ...
    (microsoft.public.sqlserver.server)
  • Re: MSDB (Subspect)
    ... I have already tried restore the msdb database from the backup but don't know why still subspected..... ...
    (microsoft.public.sqlserver.server)