|
|
||||||
|
#1
|
|
|
|
|
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 backup? Thanks |
|
|
|
#2
|
|
|
|
|
What version and edition do you have? If you have 2005 EE then you can
restore a single page and BooksOnLine will have info on that. If you are using 2005 you really should have Checksum enabled not Torn Page. But you might want to have a look at these: http://www.sqlskills.com/BLOGS/PAUL/...rruptions.aspx http://blogs.technet.com/tnspot/arch...rruptions.aspx http://www.karaszi.com/sqlserver/inf...suspect_db.asp |
|
|
| Similar Threads | |
| Thread | Thread Starter |
| Problem attach (torn page) 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... |
F Javier Gonzalez |
| 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... |
Steve |
| do I have a torn page? Ive been getting alerts like the following all morning: DESCRIPTION: Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset... |
ChrisR |
| Torn Page I found this message in the SQL Server Log: I/O error (torn page) detected during read at offset 0x000000c3878000 in file 'E:\Program Files\Microsoft SQL... |
Michael Beck |
| 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... |
Iain |
|
Privacy Policy | All times are GMT. The time now is 06:11 PM.
|
|
|