I'll add one more to the list.
- 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.
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