Difference between Backup/Restore and Detach/Attach
Posted on 2004-09-28
I've used both of these methods to copy, move and/or resurrect databases, and each seems effective, but I've never really seen these two methods compared together. Can anyone compare / contrast the advantages / disadvantages of using backup / restore vs. detach / attach? I'm especially interested in situations where one method would be better to use than the other plus any potential pitfalls and things to watch out for.