|
|
||||||
|
#1
05-26-09, 07: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, 08:10 AM
|
|
|
|
|
Hi
Do you have a last good backup? http://www.sqlskills.com/BLOGS/PAUL/...error-825.aspx Also http://www.sqlskills.com/BLOGS/PAUL/...ery-Angle.aspx "samjoseph74" <u52157@uwe> wrote in message news:@uwe [..] |
|
#3
05-26-09, 02: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, 06: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 | |
| Font corruption I've designed a website using one of the templates in publisher (Office suite 2003). I find that when I post it to the web, question marks '?' appear randomoly over the page.... |
|
| Corruption Office 2003 on WindowsXP SP2. P$ processor and 1Gb RAM I've got a document with about 4 tables. All text displayed in Arial 12 suddenly compressed into a solid black blob at... |
|
| Corruption I have a databse that is split. The frontend resides on end users PC and the backend resides on a server that is running MS Server 2000. When the backend is on this server,... |
|
| TCP/IP corruption? I have a Windows XP pro install that no longer gets an ip address, and, if you create a static ip, you can ping the gateway but can't browse(DNS). I've tried everything I... |
|
|
All times are GMT. The time now is 07:13 AM. | Privacy Policy
|
MDF Corruption