Dave62 (5/20/2014)
... 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. 😎
Don't source control and backups/replication have different goals? Yes, you can recover database code from a backup, but with database source control if someone makes a breaking change to a stored proc, you don't have to restore the entire database to roll back that stored proc.
Leonard
Madison, WI