|
|
||||||
|
#1
05-10-09, 05:05 PM
|
|
|
|
|
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
05-11-09, 01:16 AM
|
|
|
|
|
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 | |
| 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... |
|
| 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... |
|
| 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... |
|
| 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 11:10 PM. | Privacy Policy
|
Torn Page Problem....