• steveg5000 - Tuesday, December 26, 2017 9:58 AM

    What is faster, doing a backup of a database, then sending the file over the network and restoring it to a dev database or doing a detach, copying the detached MDF file and attach to the dev db?

    The purpose is simply to copy a prod database to a dev database (refresh). 

    Assume 2016 standard edition.

    They aren't functionally the same because detaching a production database so you can copy the files takes the production database offline.

    I use the backup, copy and restore approach when doing this type of thing.  If you use SQL Server logins, you'll probably have a SID mismatch between the users and the logins on the destination server because the start of authority is the instance.  You can use sp_change_users_login to find and fix them.  If the servers are on the same domain, the AD logins should be fine because the start of authority is the domain.