Steve Jones - SSC Editor (9/6/2013)
batgirl (9/6/2013)
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.
+1. Either is for moving, and in the case of DR, the primary certainly doesn't remain intact.
I'm not sure what the point is here. From a technical definition, they work differently. From a "which accomplishes what", it feels like you're playing some semantic game.
Steve, back to the original question of this discussion "difference between Attach And Restoring a Database in Sql Server". I just wanted to say that in detach/attach method, primary source is moved to target while in backup/restore, as you are using the backups of the source to refresh/build destination, the source will remain intact. Don't know if I'm putting it wrong way.
In between, Gail/Steve, I've respect for this forum and all the SQL leaders here who are here to clear our doubts. I was putting forward my point as a discussion to clarify if I'm wrong not as questioning you or anyone.