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.