I'm a long time (18 years) Database developer just now getting into SQL Server.

For all the books I've purchased on SQL Server, I have yet to find a section on how to move Databases (and Tables, Logs, Indexes) from a Test to a Production machine..


How do you do it (without having to completely redefine your Databases)?..Do you use sp_attach_db?

If the production environment mirrors the test environment can you merely copy files or is there more involved?

Could someone point me to an article or Message Thread which discusses this issue?