Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 5 down vote accepted

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.

share|improve this answer
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. –  Mark Henderson Oct 28 '10 at 19:33
@farseeker: phoebus is never wrong –  Yuck Oct 28 '10 at 20:37
@I__ - in that case, we have a paradox... –  Mark Henderson 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 posting your answer, you agree to the privacy policy and terms of service.

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