on 04-28-2011 11:06 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Resolve it and perform operation on SQL database must visit:- http://www.sqlrecoverysoftware.net/blog/sql-server-page-level-corruption.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.