• I'll add one more to the list.

    Disaster recovery

    - Know how to fix corruption

    - Know what to do when someone drops a table (though if you've done the security right, that shouldn't be possible)

    - Know how to restore to any point given your backup strategy

    - Practice various scenarios so that if something does happen, you know exactly what to do.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass