I/O error (bad page ID) detected during read at offset 0x0000000f3e4000

Hi,

Can anyone help me with this error?

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000f3e4000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\RVHS_database.mdf'.

What should i do to recover my database? Please help me outuse DBCC CHECKDB (use NOINDEX first; id an index is corrrupted it won't be a problem), then try REPAIR_FAST or REPAIR_REBUILD (it's time consuming) - see Books Online for more

Originally posted by Bluetooth
Hi,

Can anyone help me with this error?

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000f3e4000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\RVHS_database.mdf'.

What should i do to recover my database? Please help me out|||ooops, I don't think the recommended switches will do the trick. It
's REPAIR_ALLOW_DATA_LOSS that will fix page allocation errors (which is what you have here). Do it within a transaction and don't commit untill you see what repairs are done and what errors got fixed.

I understand Why can't BCP ..

Hello..
I use command BCP rceiving the following error :
(SQLState = S1000, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver
version mismatch)What is your bcp command line? Are you bcp'ing out or in? What version of
SQL are you trying to connect to.
It is hard to tell where your version error is coming from. I used a 2000
bcp client to export/import from a SQL 6.5 database and a SQL 6.5 client to
export/import from a SQL 2000 database.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Hydren" <hydrenyear@.pop.co.th> wrote in message
news:249c01c3e0d0$7371e7d0$a401280a@.phx.gbl...

quote:

---

> Hello..
> I use command BCP rceiving the following error :
> (SQLState = S1000, Native Error = 0
> Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver
> version mismatch)
>

---