• Good article but not practical for many environments. Like some other posters mentioned I think backup/restore should have been mentioned but with a slight twist. We use Litespeed to speed up and compress backups (faster copying) if your employer won't pony up the bucks , I think you can grab a free copy of SQL Safe from Idera which will give the same result. (more or less)

    For larger databases working with a compressed backup can be faster than any of the methods mentioned above.

    Cheers.

    Chris.

    Chris.