Rebuilding MSDB on SQL Server SP3 Server

  • Renuka__

    Hall of Fame

    Points: 3656

    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]

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 717276

    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.

  • Renuka__

    Hall of Fame

    Points: 3656

    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]

  • Renuka__

    Hall of Fame

    Points: 3656

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply