• Good article.

    You could have carried it a bit further. Including RESTORE VERIFYONLY as a part and parcel of your backup routines adds to the overall confidence you have in your backups. You also didn't mention getting consistency checks in place to run before full backups to ensure what's being backed up is more likely to restore.

    Still, this is important information to get out to people and you made a good start. Well done.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning