-
July 4th, 2019, 03:17 AM
#1
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)
-
July 4th, 2019, 07:47 AM
#2
Re: How To Fix SQL Database Error 824 ?
Originally Posted by dongtrien
.... 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
-
July 4th, 2019, 01:11 PM
#3
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.
-
July 4th, 2019, 11:13 PM
#4
Re: How To Fix SQL Database Error 824 ?
Originally Posted by Arjay
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 ?
-
July 5th, 2019, 12:59 AM
#5
Re: How To Fix SQL Database Error 824 ?
Originally Posted by dongtrien
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
-
July 18th, 2019, 11:24 PM
#6
Re: How To Fix SQL Database Error 824 ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|