Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    Toronto, Canada
    Posts
    30

    Unanswered: Error 823,17903,17951 server 7 sp2- UPDATE

    Regarding the above errors, I decided to apply sp4. A copy of the database was made and placed on a test server and now we cannot start the SQL Server. I have checked the registration and all seems fine. Any ideas ?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check the contents of the ERRORLOG file in LOGS directory as well as Application and System errorlog in Event Viewer and let us know what you see there.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You need to identify what the base cause of this problem is. The first step to doing that is reviewing all errors on the machine in question.

  4. #4
    Join Date
    Sep 2003
    Location
    Toronto, Canada
    Posts
    30

    Thumbs up Update : Error 823,17903,17951

    The above problem is now okay. DBAs from another Department came over and assisted with the problem. Because we had problems moving the data to another location, we decided to make a copy of the database and run DBCC repair on the production database. This fixed the problem and only a few records were lost.
    Thanks to all for your assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •