Check Catalog Msg 3854 resulting from dbcc checkdb

  • julie taylor

    SSC-Addicted

    Points: 404

    I started doing the steps in Paul's blog from June 11, 2008 and got to the 3rd bullet where I did the command sqlservr.exe -m from the correct folder.

    The following error displayed: Your SQL Server installation is either corrupt or has been tampered with (SQL Registraty Version Not Same as Server). Please uninstall then re-run setup to correct this problem

    Should I have the network person uninstall SQL2005 and reinstall it?

    I restored the backup that I made to a test db and the data looks ok in the app, so I could restore the db, after sql2005 was installed again.

    Any advice is greatly appreciated.

    Julie

  • Denby

    Hall of Fame

    Points: 3120

    I just last week did an upgrade to 2005 and encountered the same problem as you are having. i also used paul randals blog which corrected problems related to syscols but not sysobjects.

    I open a ticket with microsoft and this is what and recieved two email responses.

    EMAIL1

    (

    Root Cause (if known) – This is a known issue that occurs when a table has been deleted not using the established methods of deleting database objects (e.g. modifying the system tables). The error existed in SQL 2000 but was not checked by DBCC CheckDB. SQL 2005 began making this check in DBCC CheckDB.

    Resolution – There are two supported options:

    1. Ignore the error. Your database performance should not be affected by this.

    2. Create a new database and move all data and objects to the new database.

    )

    EMAIL 2

    (

    Resolution – I have submitting this question to the dev team and here are the two possible work arounds to your problem.

    1st

    Bcp out all the data, fix up 2000 databases before upgrade to Yukon, and bcp in the data.

    2nd one (unsupported)

    Remove the column thru DAC connection when SQL server started in maintenance mode. After issuing “Delete sys.syscolpars where id = ” thru DAC, restart the server immediately. This will also leave a message in your error log every time you restart SQL Server.

    )

    The most viable option here for me is to use email 1 resolution 2 and although i haven't tried email 2 resolution 2. Either way i'll have to schedule downtime a month from now.

    hope this helps

  • MostInterestingMan

    SSCertifiable

    Points: 6291

    ..

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • Bilal Ayub

    SSC-Addicted

    Points: 411

    Probably below steps will give practical steps to find workaround. 

    http://thesqlstuff.blogspot.my/2017/02/dbcc-checkdb-failed-due-to-invalid.html

  • Gail Shaw

    SSC Guru

    Points: 1004424

    Please note: 9 year old thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Johnson Welch

    SSCoach

    Points: 18748

    The reason of getting SQL error 8992 could be many. Check out various possible reasons of getting this error and step by step process to fix it.
    https://www.systoolsgroup.com/updates/fix-sql-server-error-8992/

Viewing 6 posts - 16 through 21 (of 21 total)

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