SQL Server Error

[Mainco]

First of all apologies if this is the wrong forum to post this.

When we ran our database backups the following error messages were found in the SQL Server Error 7 log. Can someone advise me how to determine which, if any table is corrupt and which database it is coming from.

2005-01-14 03:43:45.65 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (4:193671). The PageId in the page header = (0:0).

2005-01-14 03:43:45.67 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (4:193670). The PageId in the page header = (0:0).

2005-01-14 03:43:45.68 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (4:193669). The PageId in the page header = (0:0).

 

[mrdenny]

Database 4 is msdb. Run checkdb on the msdb database and it should give you more info.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Mainco]

Thanks for the information checkdb came back with:-

CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.




Alan

 

[mrdenny]

I'd check the other databases as well. Just to be safe.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Mainco]

My apologies, I should have said I did that to all the others sasme result