Not a bad idea. It's currently about 1.6gigs but I could probably get that down to sub 200megs for a download. It'll knock out the dev server for an hour or so, giving me a nice break.
Paolo > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > Sent: 01 August 2002 13:13 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT: SQL7 Page Data Corruption > > > 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] > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
