error 823: I/O error (torn page) detected during read at offset in a file

[Former Member]

Hi ,

We got an error 823 torn page in attaching database. Is there any solution to recover from this. We do not have the backup of database also.

The database unable to attach and it has the same error in C:\programfiles....\master.mdf and as well as main database F:\ze1data1.mdf also.

Is there any solution to this ? Try to perform DBCC CHECKDB but it is unable to proceed because of not having single user mode.

Thanks

Srikanth

[sivakumar_kilari3 · Accepted solution]

Hi,

You can make it as a single user like this.

Use database_name

GO

ALTER DATABASE database_name SET SINGLE_USER

GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)

GO

to return to multi-user mode:

ALTER <database-name> SET MULTI_USER

[http://support.microsoft.com/kb/828339]

Thanks

Siva

[Former Member · Accepted solution]

Hi,

I performed the above dbcc checkdb command but its not finding single value, actually i am checking this query on "master.mdf" , which actually resides in " C:\programfiles\MsSql\...\master.mdf".

Actually when i am attaching with the database i have encountered the problem of "error 823 i/o torn page error".

Is there any solution to recover from this situation. We dont have backup of database also .

Any one can have knowledge on thiis ? Please provide good soultion to recover from this situation.

Thanks

Srikanth

[clas_hortien · Accepted solution]

Hello,

you should open a SAP message in the BC-DB-MSS component for this, to get helped here.

If you put in my name, the message will come to the Dev. Support quickly.

Best regards

Clas Hortien

[Former Member]

Resolve it and perform operation on SQL database must visit:- http://www.sqlrecoverysoftware.net/blog/sql-server-page-level-corruption.html