• ... Do me a favor; put your database object code in source control. Add all your DDL for tables, views, functions, stored procedures, and anything else you use. ...

    We have our software application code in version control and we backup our production and development SQL servers daily. We don't have the SQL code in source control but I don't know how we would lose anything if a production or development server crashed as long as we have the backups.

    We also have our production and development servers running on VM's with snapshots and replication to an off-site co-location.

    If we find ourselves in a situations where we can't recover data, it's going to be an event so significant that work and data will be the last things on our minds. 😎