August 7, 2008 at 9:54 pm
Hi,
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.
Present Scenario:
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.
Thank you.
Renuka B
[font="Verdana"]Renuka__[/font]
August 10, 2008 at 5:05 pm
I don't know if you can use the English version on the German instance. I think the functionality is the same, perhaps there will be verbage changes of data.
Do you not have a backup of msdb? You should be backing this up regularly.
Also, if you have checkdb errors, they are almost always hardware related in some way.
August 10, 2008 at 10:24 pm
Thank you Steve for your reply.
We tried with 2 previous backup sets and had no luck.
We are now given a machine which is built completely in German interface (same as production server); We would be testing this scenario on this test server.
I will post the results after we finish our testing.
Thanks once again.
[font="Verdana"]Renuka__[/font]
October 15, 2008 at 2:43 am
There is no impact.
we have rebuilt MSDB from regular service pack files (English) on German Built SQL instance and there are no issues found.
[font="Verdana"]Renuka__[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply