|
|
||||||
|
#1
09-12-07, 08:57 AM
|
|
|
|
|
Hi,
Can you help me?. I have a problem with a SQL 2000 Database. I have not any backup. I can not attach my database because I have this error : Error 823: I/O error (torn page) detected during read at offset. Can you help me?. Thanks |
|
|
|
#2
09-12-07, 09:44 AM
|
|
|
|
|
Hi,
Torn pages cannot be fixed. The only way you can recover from them is by restoring from a backup. Since you do not have a backup, your only option is to call in a data recovery specialist who specializes in SQL Server. Jonathan F Javier Gonzalez wrote: [..] |
|
#3
09-12-07, 09:47 AM
|
|
|
|
|
There is a KB about this issue and maybe you wanna take a look at that:
http://support.microsoft.com/default.aspx/kb/828339 And this article may give you an idea in case of a recovery: [url down] |
|
#4
09-12-07, 10:23 AM
|
|
|
|
|
Hi, thanks,
Do you know what means "attach database as suspect" ? Is it possible?. How? Thanks |
|
#5
09-12-07, 12:08 PM
|
|
|
|
|
When you experience problems with your database (for example lost ldf of mdf
files or something) your databases status will be Suspect. In your situation, you can't even attach your database. So the author of the mentioned article tries a way to save your data. Author says how you can do it in the article. Here's a quote: Create a database with an mdf of the same size as the old one stop the server. Copy the corrupt mdf over the newly created one. Restart the server - the database should be suspect. I'm not sure if it works for you or not however you do not have much alternatives. Do not neglect taking a backup of your database before performing these actions for alternative recovery solutions that you may find later. |
|
|
| Similar Threads | |
| Torn Page Problem.... Dear Professional, I would appreicate if anyone guide me how I know my database has Torn Page problem and how to restore the specific torn page from my database... |
|
| Torn page detected but can't find problem We received an alert this morning "I/O error (torn page) detected during read at offset 0x0000000203c000 in file 'd:\data\data\CFS_Data.MDF" then about 20 minutes later, "I/O... |
|
| Torn page during attach ... One of our customers had their server die. The resurrected what they could through talking to their RAID tech support and were able to at least boot the OS. SQL Server failed... |
|
| torn page problem in MSDE I'm just trially a new ISP And am trying to transfer my application (VB / Web classes SQL Server) to the new server. The old system uses W2K server and SQL Server 2000. The... |
|
| Torn page I get a message of a torn page in a databse. Can I do anything to save the data? |
|
|
All times are GMT. The time now is 01:15 AM. | Privacy Policy
|
Problem attach (torn page)