I forgot to list that as a tried option - unfortunately, a test restore failed. This db passes a dbcc checkdb run, btw. I found another db that doesn't and is complaining of disk read errors too.
Sean Rector, MCSE From: Kim Longenbaugh [mailto:k...@colonialsavings.com] Sent: Wednesday, July 13, 2011 11:16 AM To: NT System Admin Issues Subject: RE: Houston, we have a problem - SAN Disk corruption I'd suggest a restore from backup now that you've fixed the hardware issues From: Sean Rector [mailto:sean.rec...@vaopera.org] Sent: Wednesday, July 13, 2011 8:54 AM To: NT System Admin Issues Subject: Houston, we have a problem - SAN Disk corruption Hey guys, I've run into a problem where my SAN (HP Storageworks 1200r) had two disks die, affecting three volumes. One of those was the SQL data volume that my SQL Cluster shares. This is SQL 2008 (SP2) on Windows Server 2008 R2 (SP1). In particular, one MDF file appears to have been damaged. Symptoms are: · I try to copy the MDF (after detaching from SQL), and it fails with a Read error at 3.09GB left (it's 5.25G in size). · I try to use SQL to back the db up and that fails at 60%. · I was able to move the DB to another folder on the same volume, but still the above two issues happen. Dbcc checkdb reports no errors, but I need to get this fixed ASAP. We're replacing this with a Dell Equallogic shortly (within two weeks). Let me know if you need any more information. Sean Rector, MCSE Information Technology Manager Virginia Opera Association E-Mail: sean.rec...@vaopera.org <mailto:sean.rec...@vaopera.org> Phone: (757) 213-4548 (direct line) {+} Tickets and Subscriptions On Sale Now! Aida | Hansel And Gretel | Orphée | The Mikado Visit us online at www.VaOpera.org <http://www.vaopera.org/> or call 1-866-OPERA-VA Experience the Beauty, Power & Passion of Virginia Opera. ________________________________ This e-mail and any attached files are confidential and intended solely for the intended recipient(s). Unless otherwise specified, persons unnamed as recipients may not read, distribute, copy or alter this e-mail. Any views or opinions expressed in this e-mail belong to the author and may not necessarily represent those of Virginia Opera. Although precautions have been taken to ensure no viruses are present, Virginia Opera cannot accept responsibility for any loss or damage that may arise from the use of this e-mail or attachments. {*} ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin