Author |
Topic |
venkath
Posting Yak Master
202 Posts |
Posted - 2006-07-06 : 23:11:05
|
Hi allWhen 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 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-07-07 : 00:55:50
|
It seems to be a hardware failure on the disk where you have you database. Make a backup as soon as possible with log, and then replace disk.Peter LarssonHelsingborg, Sweden |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-07 : 01:05:12
|
run a DBCC CHECKDB and post the results.Do not opt for any repairs, just post the results. Also, you may want to post this question in the "Data Corruption Issues" forum here. -ec |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-07-07 : 01:19:25
|
Hi eyechart...when i run the DBCC CHECKDB against the database..i got the following error..Server: Msg 8946, Level 16, State 12, Line 2Table 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.Server: Msg 7995, Level 16, State 1, Line 1Database 'A2PD' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.DBCC execution completed. If DBCC printed error messages, contact your system administrator.How can i proceed now.. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-07 : 01:24:02
|
quote: Originally posted by venkath Hi eyechart...when i run the DBCC CHECKDB against the database..i got the following error..Server: Msg 8946, Level 16, State 12, Line 2Table 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.Server: Msg 7995, Level 16, State 1, Line 1Database 'A2PD' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.DBCC execution completed. If DBCC printed error messages, contact your system administrator.How can i proceed now..
post your original message and the DBCC output in the "Data Corruption Issues" forum here. Paul Randall (dev lead for SQL Storage engine) monitors that forum and usually responds within a day to questions like this. Whatever you do, do not do and repairs on the database. Also, do not detach the database. Post your message and then wait for paul to tell you what to do -ec |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-07-07 : 01:27:34
|
Ok..Since it is not production database..regular backups are not taken..The database is in Full Recovery Model..Thanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-07 : 11:43:12
|
quote: Originally posted by venkath Ok..Since it is not production database..regular backups are not taken..The database is in Full Recovery Model..Thanks
Not being a production database is not a reason for not making regular backups.The criteria should be, "Is anything in the database important enough to not want to lose or costly to replace?" If it is important, then you need a regular backup.CODO ERGO SUM |
|
|
|