dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Thread: How To Fix SQL Database Error 824 ?

  1. #1
    Join Date
    Sep 2007
    Posts
    318

    How To Fix SQL Database Error 824 ?

    My data SQL Server is reported this error, How does this error fix you ?

    SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
    During redoing of a logged operation in database 'MyData', an error occurred at log record ID (30182:834:13). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
    Could not open new database 'MyData'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 824)

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    19,423

    Re: How To Fix SQL Database Error 824 ?

    Quote Originally Posted by dongtrien View Post
    .... This error can be caused by many factors; for more information, see SQL Server Books Online.
    ...
    So have you found any info in "SQL Server Books Online"?
    Victor Nijegorodov

  3. #3
    Arjay's Avatar
    Arjay is offline Moderator / MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,033

    Re: How To Fix SQL Database Error 824 ?

    Did you perform DBCC CHECKDB ? You can't ask for a better error message than one that tells you what to do and where to look for more info.

  4. #4
    Join Date
    Sep 2007
    Posts
    318

    Re: How To Fix SQL Database Error 824 ?

    Quote Originally Posted by Arjay View Post
    Did you perform DBCC CHECKDB ? You can't ask for a better error message than one that tells you what to do and where to look for more info.
    I have not used DBCC CHECKDB because I do not know how to use DBCC CHECKDB, how are the steps taken, you know how to use them ? Do you have this video click this DBCC CHECKDB manual ?

  5. #5
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    19,423

    Re: How To Fix SQL Database Error 824 ?

    Quote Originally Posted by dongtrien View Post
    I have not used DBCC CHECKDB because I do not know how to use DBCC CHECKDB, how are the steps taken...
    Did you read about DBCC CHECKDB (Transact-SQL)?

    And how about "SQL Server Books Online"?
    Victor Nijegorodov

  6. #6
    Join Date
    Sep 2007
    Posts
    318

    Re: How To Fix SQL Database Error 824 ?

    thank you very much

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)