Robin Lawrence
rgilimited at btconnect.com
Wed Dec 17 08:46:07 CST 2003
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