Home » Topic » How to Resolve MS SQL Error 824?

How to Resolve MS SQL Error 824?

Lincoln Burrows ~ Modified: July 30th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to Resolve MS SQL Error 824?

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • July 31, 2015 at 12:31 pm #407 Score: 0
    Stephen West
    Moderator
    4 pts

    Run the Following Command:
    DBCC CheckDB(<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLOCK

    September 2, 2015 at 9:52 am #549 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Try this:

    ALTER DATABASE corrupted_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC ChECKDB ('corrupted_db', REPAIR_ALLOW_DATA_LOSS) 
ALTER DATABASE corrupted_db SET MULTI_USER

    but there is very high chance of data loss

    April 5, 2016 at 12:28 pm #1831 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    After a long search on google I have found this article please go this one it may be helpful to you. You can easily troubleshoot the error 824 easily. http://sqltechtips.blogspot.in/2015/11/troubleshooting-error-824.html

    April 27, 2016 at 9:56 am #1987 Score: 0
    Stephen West
    Moderator
    4 pts

    Typically the leading cause of corruption is problems with the IO subsystem.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.