Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-02-08 : 21:14:23
|
| Hi,I have a database on the server which is in production and I would like to create another copy and use it for testing purpose. so the application can point to the test database for testing purpose.What is the best way to do? I guess I have to name the test one with different name right?can I do it without detach the production one? or just copy the database - tables structures from the currnet one?Thanks! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-08 : 22:18:18
|
use BACKUP & RESTORE to backup the production database and restored it to another server or database with diff name.
KH |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-09 : 00:58:14
|
| "copy the database - tables structures "If you just want the Table Structures you can Script them from the current database, and then run the script on a new, empty, database.Kristen |
|
|
|
|
|
|
create a test copy of the database?