|
|
||||||
|
#1
05-26-09, 08:54 AM
|
|
|
|
|
While writing to the SQL Server database, I might encounter the below error
message: “Error 823 I/O error <error> detected during <operation> at offset <offset> in file '<file>'” This error message may occur every time when I start SQL Server and access the MDF file. Please suggest me what I do to resolve this error. |
|
|
|
#2
05-26-09, 09:10 AM
|
|
|
|
|
Hi
Do you have a last good backup? [url down] Also [url down] "samjoseph74" <u52157@uwe> wrote in message news:@uwe [..] |
|
#3
05-26-09, 03:29 PM
|
|
|
|
|
Run DBCC CheckDB on the db(s) and see what sad situation it lists out - you
most likely have corrupted db(s) due to an I/O issue, so check that out first before you do a restore and have it get corrupted again - I've had issues with our SAN in the past disconnecting all-of-a-sudden-like and corrupting dbs (usually one or two tables, but a sad situation none the less). "samjoseph74" wrote: [..] |
|
#4
05-27-09, 07:01 AM
|
|
|
|
|
Use DBCC CHECKDB command to check any logical errors in the database. It is
an in-built command in SQL Server to fix application level errors. Else you have to use SQL Database Recovery software to scan the corrupted database and recover all the inaccessible data from it. These software are specifically designed to Repair SQL database in most of the corruption scenarios. I hope your problem will be resolved by using DBCC CHECKBD Command otherwise use Stellar Phoenix SQL Recovery Software. samjoseph74 wrote: [..] |
|
|
| Similar Threads | |
| XP corruption Something happened last night to my system such that I think some system files became corrupted. I am finally able to boot up, but not without some "barking" messages. ... |
|
| Corruption? I have 3 newservers in OE6 (SP2) - news.microsoft.com; free.teranews.com and my isp's group. Within the past hour all three have had the subscribed newsgroups changed; ie... |
|
| MDB corruption I have an 81mb mdb file that has a corrupted record in it. A compact and repair does not remove the corruption (also tried jetcomp). The record show as #error in one of the... |
|
| *.dbx corruption...cause?? Hello everyone, I have a few corrupted OE6 *.dbx files on my hard disk. I'm just curious if any other factor other than an anti-virus' e-mail scanner and OE6's auto-compact... |
|
| Corruption Hello, I'm in a tight spot and I hope you can help. My client's table has a last record that reads #Deleted all accross the last line. The file is still operating but is... |
|
|
All times are GMT. The time now is 12:07 PM. | Privacy Policy
|
MDF Corruption