Pls Help- I/O error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Pls Help- I/O error

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2006-07-07 : 01:09:26

Hi all

When i am udating a table.. i am getting the following error...
UPDATE SALES_ORDER
SET CC_NUMBER = PAYMENT_NUMBER
WHERE PAYMENT_METHOD_CODE IN ('AMEX', 'DISC','MC','VISA'): [POETICAPP]I/O error 1(Incorrect function.) detected during read at offset 0x0000000000c000 in file 'E:\Data\A2PD_22.mdf'.
08:37:34 [ERROR ] Exception in upgrade [POETICAPP]I/O error 1(Incorrect function.) detected during read at offset 0x0000000000c000 in file 'E:\Data\A2PD_22.mdf'.

Pls help me how to handle this issue..

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-07 : 01:26:23

original thread w/DBCC output http://sqlteam.com/forums/topic.asp?TOPIC_ID=68749

-ec

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-07 : 01:31:31

from the original thread

quote:
Ok..
Since it is not production database..regular backups are not taken..
The database is in Full Recovery Model..

Thanks

do you have any backups?

-ec

venkath
Posting Yak Master

202 Posts

Posted - 2006-07-07 : 01:34:39

Yes..We have a back up of this database taken couple of months ago..

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-07-07 : 01:43:33

1) have you looked through this forum for other threads around similar issues?
2) have you done root cause analysis to find out why this happened?
3) are you interested in getting the data back in this database? I'm assuming probably not given that you don't have any recent backups...

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

venkath
Posting Yak Master

202 Posts

Posted - 2006-07-07 : 01:50:54

Hi Paul...

1)No
2)Since i am a Trainee DBA..this is the first time i am experiencing the error..
3)If possible..it is better if the data is restored other wise..what are the alternative i have...?

Thanks

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-07-07 : 02:01:15

ok - have a quick look this forum for other IO errors to save me spending a bunch of time repeating myself (it's 11pm here).

Post the output from

DBCC CHECKDB (yourdb) WITH ALL_ERRORMSGS, NO_INFOMSGS

Do you have a more experienced DBA who is mentoring you? If so, what is their advice?

You can't restore the data if you don't have a backup. Using the backups you have, you'll lost two month's work. You only alternative is to run repair, which will cause data loss.

I encourage you to go to my blog and read it all, plus subscribe to it for future posts. See https://blogs.msdn.com/sqlserverstorageengine/default.aspx

(I won't see any reply until later tomorrow PST)

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

venkath
Posting Yak Master

202 Posts

Posted - 2006-07-07 : 02:24:00

There r no related threads in the data corruption forums.

DBCC CHECKDB WITH ALL_ERRORMSGS,NO_INFOMSGS

When i run the above command..i got the following error..
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (20:234552) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-07 : 04:14:47

quote:
Originally posted by venkath

There r no related threads in the data corruption forums.

DBCC CHECKDB WITH ALL_ERRORMSGS,NO_INFOMSGS

When i run the above command..i got the following error..
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (20:234552) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.

Thanks

I think your only option is to restore from backup, but you should should probably wait for paul to give you the bad news..

here is a message with a similar error that paul responded to. Not good news..

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/36723e7ff323fdbd/

-ec

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-07-07 : 16:27:32

Yep - corrupt PFS pages can't be repaired so you have no choice but to restore from the backup. You may be able to salvage some data from the database but that's way beyond the scope of this forum (I really should start a company to do this).

As a trainee DBA, this is one of the best lessons you can learn early on - don't let it happen to you when you're responsible for the backup strategy.

Please go and read my blog too.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Kristen
Test

22859 Posts

Posted - 2006-07-10 : 07:42:49

"I really should start a company to do this"

Let me know if you need an office junior

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources