Brief Description of the issue:
Server: SQL 2000 SP3
We have one of our maintenance jobs (Integrity Checks) failed with error showing on MSDB; Later, when we tried CHECKDB on MSDB, there were errorslike:
Table error: Object ID 6, index ID 1. Page (1:263) was not seen in the scan although its parent (1:51) and previous (1:549) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 6, index ID 1. Page (1:550) is missing a reference from previous page (1:263). Possible chain linkage problem.
The objectID 6 is syscomments table.
There are no hardware related problems on the server. CHECKDB with Repair dint work.
We are now trying to re-build MSDB using INSTMSDB.SQL from SP3 disk. The server (its production box) is in Frankfurt and the interface is in German. We do not have any test server with the same settings and configuration.
The rebuild MSDB worked fine on one of the test servers which is in English interface.
Now, I am not sure if we can use the same INSTMSDB.SQL on the German server as well. I remember we choose the Language while applying service pack. Now, on this server, while applying SP3, the earlier DBAs might have chosen German as the language and now if I run INSTMSDB.SQL directly from the disk on this German Server, are there going to be any issues. I hope I dint confuse you guys.
Any input is much appreciated.