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 |
|
ann_tech
Starting Member
1 Post |
 Posted - 2005-06-24 : 04:19:48
|
| I have a SQL Server machine where a database is running. I need to replicate the same database in another SQL Server m/c. When I use the DTS to do this, the problems I face are the foll :1) Around 20 tables get created additionally in the new DB.2) The views do not get created.3) The users do not get created.Please help out.Regards,Ann. |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-07-21 : 16:22:49
|
| Why not just to a save/restore to get the database to the other server ?What's "m/c" ? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-21 : 16:57:15
|
| Run BACKUP DATABASE on the source database. Run RESTORE DATABASE using a different database name and use the WITH MOVE option so that you don't overwrite the original MDF and LDF. This method will grab everything except logins which are stored in master.Tara |
|
|
|
|
|
|
New DB creation via DTS - errors