Hi Michelle,
I think that all of your DDL files should probably be under source control. Creation scripts for tables / indexes / views / stored procedures, etc. This way you can build the entire thing from scratch at any time to any previous state.
When I complete a new database feature, I label the code in source control so I have a decent set of rollback points.