• GilaMonster (9/6/2013)


    If I'm moving databases from one instance to another, I'll use backup/restore. It definitely is a way to move databases.

    That is obviously one's choice. In my opinion, moving a DB technically is moving one from say A to B such that after the movement only B has the moved database (so the primary database is moved to B and is now not present in A, where detach/attach will work). While with restore your primary copy will remain intact in server A and you are refreshing/creating the DB in server B.