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 |
|
vasanthhepsy
Starting Member
48 Posts |
 Posted - 2008-01-31 : 21:19:58
|
Hi Patrons,Can any one tell me how and what are the steps to Clone the Database and how do the set of users (lets say 300) will be connected to that Cloned Database.Your helping steps would be appreciated. Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-31 : 23:20:32
|
| Do backup/restore, then remap db user to sql login with sp_change_users_login. And you can copy sql login with ssis package. |
 |
|
|
|
|
|
Cloning Database and Connecting users