backup the database, download to your dev server and run a maintenance plan on it. In the maintenance plan you can fix any errors and chck the database integrety. if this works fine, you can setup same plan to run on your live server
-----Original Message----- From: Paolo Piponi [mailto:[EMAIL PROTECTED]] Sent: 01 August 2002 11:51 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] OT: SQL7 Page Data Corruption Anyone ever had this: "I/O error (bad page ID) detected during read of BUF pointer = " It appears that a particular range of records (primary key IDs 539498-541179) are corrupt. The table still accepts inserts but any query that runs over this range within a table of 2m records causes an error. I could run a DBBC CHECKTABLE but this is a live database and I can't take it offline for the hour or so this process might need. Any suggestions from the DBAs out there? Paolo -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
