I've been using Serena Version Manager for over 8 years now. I can't really imagine life without it. Stored Procedures, Views, SSRS Reports, Entire SSAS solutions, even some documents and jpegs get checked in there. I don't have to worry about anyone over-writing my code when I have anything checked out. If I toast something I'm working on, I always have the option to refresh back to the latest version that was checked in. I can do a diff between files and see what's changed, plus there are notes kept with each version change along with the last check-in date. All work is bridged back to our project documentation, so you can always see why the change was made. I probably wouldn't consider a position elsewhere if they didn't have similar capabilties available. It's just too easy to do, and it adds such a security blanket. It would be foolish not to use a VCS.
In addition to that, we have a shared drive that automatically backs up every hour. It always keeps a couple of days worth of snapshots, and all versions are available through file properties. We can save new development and anything that's checked out there, and you can easily get a version of a file backed up from earlier in the day before you had problems without going to tape. You can get whole folders back if necessary. I don't need to do it that often, but boy is it nice to have when you need it.