[dba-SQLServer]Torn page

Haslett, Andrew andrew.haslett at ilc.gov.au
Wed Dec 17 18:45:42 CST 2003


There's also a 'torn-page-detection' database setting, but I'm not sure if
this will actually prevent errors.. 

-----Original Message-----
From: Robin Lawrence [mailto:rgilimited at btconnect.com] 
Sent: Thursday, 18 December 2003 1:16 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Torn page

John,
Further info at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodt
echnol/sql/reskit/sql7res/part8/sqc10.asp

Q: What happens when SQL Server detects a torn page? 

A: When a torn page is detected, a severe I/O error is raised. This error
closes the connection. The database is marked suspect only if the torn page
is detected during recovery. 

Q: How can I recover from torn pages? 

A: Restoring the database from a backup and rolling the transaction log
forward should correct the problem with no data loss. 


HTH
Rgds
Robin Lawrence





-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: 17 December 2003 13:28
To: SQLServer
Subject: [dba-SQLServer]Torn page


I get an error entering data into a table of my billing database - "insert
failed - torn page detected".  If I go into the table I am attempting to
enter data in,. nothing but #error# in all fields.  Relinked table, same
thing.

Is this reparable?  If so how?

John W. Colby
www.ColbyConsulting.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.


More information about the dba-SQLServer mailing list