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 want to restore a database but it show me a mistake

I need restore a database but appears the nex error
Microsoft SQL-DMO 9 (ODBC SQLState: 42000)
Tha backup set holds a backup of a database other than the existing 'ACCESSCONTROL' database Backup or Restore operation terminating abnormally
What Can I Do for to resolve this error?
The SqlServer version 7.0
The backup that you are restoring is of a different databse to the one =
you are restoring, thus the error you are getting is a warning that =
youwill be overwriting an existing database wich you may not intend to =
do. The RESTORE SQl statement has an option WITH REPLACE, which =
overrides this warning so if you really want to do what you are asking =
it to do adding the equivalent optionshould fix your problem. If you =
have yoiur own app using SQl DMO, then there should be an equivalent =
option within DMO.
Mike John
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message =
news:0CC8EAC8-8200-47B0-9D8A-F3E5743F9837@.microsoft.com...
> I need restore a database but appears the nex error
> Microsoft SQL-DMO 9 (ODBC SQLState: 42000)
> Tha backup set holds a backup of a database other than the existing =
'ACCESSCONTROL' database Backup or Restore operation terminating =
abnormally
> What Can I Do for to resolve this error?
> The SqlServer version 7.0

I want to restore a database but it show me a mistake

I need restore a database but appears the nex error
Microsoft SQL-DMO 9 (ODBC SQLState: 42000)
Tha backup set holds a backup of a database other than the existing 'ACCESSC
ONTROL' database Backup or Restore operation terminating abnormally
What Can I Do for to resolve this error?
The SqlServer version 7.0The backup that you are restoring is of a different databse to the one =
you are restoring, thus the error you are getting is a warning that =
youwill be overwriting an existing database wich you may not intend to =
do. The RESTORE SQl statement has an option WITH REPLACE, which =
overrides this warning so if you really want to do what you are asking =
it to do adding the equivalent optionshould fix your problem. If you =
have yoiur own app using SQl DMO, then there should be an equivalent =
option within DMO.
Mike John
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message =
news:0CC8EAC8-8200-47B0-9D8A-F3E5743F9837@.microsoft.com...
> I need restore a database but appears the nex error
> Microsoft SQL-DMO 9 (ODBC SQLState: 42000)
> Tha backup set holds a backup of a database other than the existing =
'ACCESSCONTROL' database Backup or Restore operation terminating =
abnormally
> What Can I Do for to resolve this error?
> The SqlServer version 7.0