The above is correct, but something that makes life pretty easy when constantly restoring databases from a production environment into DEV/QA is to write a little post restore procedure that...

- Changes recovery models to simple

- Set autoshrink ok

- Shrink log files