i need make an exact copy of a database on the same server. is there an easy way to do this?


Backup and restore it under a different name. Or install a named instance and backup from the DEFAULT instance and restore to the named instance under the same name.

  • And don't use the Database Copy Wizard, because it's a piece of junk that fails 90% of the time.
    – phoebus
    Oct 28 '10 at 17:23
  • @Phoebus - I don't know if I'd go that far, it has its uses, but doing it this way is generally quicker anyway. Oct 28 '10 at 19:33
  • @farseeker: phoebus is never wrong Oct 28 '10 at 20:37
  • @I__ - in that case, we have a paradox... Oct 28 '10 at 20:41
  • @Farseeker Yeah, I just always seem to end up frustrated when I try to use it;) @I__ I appreciate the vote of confidence!
    – phoebus
    Oct 28 '10 at 20:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.