Home / server / Questions / 195864
Accepted
Alex Gordon
Asked: 2010-10-29 09:02:18 +0800 CST

sql server 2008 how do i make an exact copy of a database on the same server?

  • 772

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

sql-server-2008

1 Answers

  1. Best Answer

    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.

    • 5