Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
parrot
Posting Yak Master
132 Posts |
 Posted - 2008-11-17 : 12:16:20
|
When I click on the Design Table to make changes to my SQL database I get an error message indicating a catastrophic error. It then asks me if I wish to reconnect to the Server and if I say yes, I get a "torn page" error message shown below. Does anyone know what a "torn page" error message is and how to correct for the error. The SQL 2005 database can be accessed programatically but not thru the Design Table.Dave |
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-11-18 : 00:21:37
|
| To resolve this problem, first run the DBCC CHECKDB statement on the database that is associated with the file in the error message. If the DBCC CHECKDB statement reports errors, correct those errors before you troubleshoot this problem. If the problem persists even after the DBCC CHECKDB errors have been corrected, or if the DBCC CHECKDB statement does not report any errors, review the Microsoft Windows NT system event log for any system errors or disk-related errors. You can also contact your hardware vendor to run any appropriate diagnostics. |
 |
|
|
|
|
|
Torn page error