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 |
|
hujirong
Starting Member
4 Posts |
 Posted - 2008-07-08 : 20:52:21
|
| HiFor an application (Rational ClearQuest) I need to duplicate a production environment. CQ has two databases, schema db and user db. Means I want to make an exact copy of these two databases, but on the same SQL Server.Which tool shall I use and how can this be done. Detailed precedures are greatly appreciated.Jirong |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-08 : 21:55:15
|
Backup the databases and restored it to a new database. You can use SQL Server Management Studio to do it
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 22:43:19
|
| Don't make duplicate database in Production server. You need to restore in UAT or Dev server.Database takes resources. |
|
|
|
|
|
|
How to copy a database?