• sqlnaive (9/6/2013)


    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.

    In my opinion, either process can be used to move or copy a database and neither has anything to do with whether the primary copy remains intact.