Home Forums SQL Server 2005 Data Corruption CHKDSK on a SAN Volume RE: CHKDSK on a SAN Volume

  • December 13, 2012 at 8:11 pm

    #1568538

    NMHDBA (12/13/2012)

    I know that this topic is a bit old, but I have a very similar question.

    Every two weeks we perform server/database maintenance; altering indexes, Windows updates and a server reboot. My issue periodically appears between maintenance weeks with a System error Event ID 55 in the event viewer: "The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume XDATA."

    This volume is on our SAN and I've determined that I need to perform a CHKDSK since the volume is marked as dirty.

    I understand the differences between CHKDSK /F & CHKDSK /R. My question is since I'm not performing a CHKDSK /R should I be worried about database files on this volume if I perform a CHKDSK /F?

    Call the SAN vendor and tell them to come fix it or replace it! That kind of corruption should only happen about once every hudred years or so on a SAN.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)