• SQLRNNR (10/21/2014)


    Can you please post exactly what you did to rebuild the master database?

    Also, do you by chance have another instance on the server? Please confirm that the appropriate server has been connected to when performing the checkdb as well as the master database rebuild.

    Thanks for reply.

    What I did is following MSDN suggestion to rebuild the sysyem database:

    1. backup all system databases

    2. shut down sql service

    3. rename system database mdf file to *_bk (not necessary I believe, but just did it in case the rebuild cannot over-write the file)

    4. use command line console to rebuild the system database

    5. review rebuild summary report, and confirmed there is no error report under error section

    6. confirmed datestamp of the master.mdf file under data folder has been changed

    but when service is back online, I did a dbcc checkdb again against master database, the consistency error is still there.

    For your 2nd question, the server is a single instance server so there is no other instance installed on this server. (Just out of the topic, even it is a multi-instance server, DBCC CheckDB should not post any error, is this correct?)