You can store text and binary files in CVS, regardless of the file content ie. .sql, .c, .java, etc...
If you are starting from scratch, you should determine on what linux/unix platform you will run and set up a server. Then you can decide the auth model ie. pserver, shell, ssh. Set up the user(s) as per the auth model and then initialize & populate a repository.
Some docs could be found at http://ximbiot.com/cvs/manual but there are many sources on the internet (google cvs documentation).
Good luck,
Cristian
If you don't have a source code management server in place already I would strongly recommend Subversion. The CVS project has not seen much activity for years.