• And to add to Jeff's and Gail's posts: restores. A lot of people take backups. Not everyone restore their backups, or understand how they should do in a disaster scenarios.

    There are two important reasons why you regularly should restore your backups (in environment different from production):

    1) To make sure that you are familiar with the procedure.

    2) The backups are actually good and valid.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]