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 |
|
MTech8
Starting Member
10 Posts |
 Posted - 2005-10-27 : 18:38:57
|
| Hello. I need some help please.Scenario:I have a database db1 on Machine1 (M1). I want to re-create db1 and update it (when there is new data) on a database called db2 on Machine2) M2.What I have done so far is to use the DTS Import/Export Wizard.I set up the source & destination appropriately and choose to copy objects and data between the SQL Databases. But I get an error stating: [Microsoft][ODBC SQL Server Driver][SQL Server][Windows NT user or group 'N1\ASPNET' not found. Check name again.I suspect that the the user 'M1\ASPNET' is not in the system's list of users. But I am unable to recreate this guy on the M2. What do I need to do? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-27 : 18:43:31
|
| The easiest way to move a database to a different server is to backup the source, copy the backup file to the destination, then restore it on the destination. It is much faster and simpler than DTS.Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-27 : 22:53:01
|
you can remove that user first and just add it later on, if it's a windows account, then it must have been removed which is why referencing to it invokes the errorquote:
But I am unable to recreate this guy on the M2
or the destination server is unable to recognize that group/user, firewall stuff/trusted connection between machines, etc--------------------keeping it simple... |
|
|
|
MTech8
Starting Member
10 Posts |
Posted - 2005-10-28 : 12:26:13
|
jen: Thanxs for the tip. What you said makes sense. I need to look into how to properly set up users & groups to fix this problem. I'll repost what I learned and how I solved this problem (if I'm am to figure it out)  tduggan: Thanxs. I do know about backing up and restoring. But it entails a couple more steps(actually copying the file to the location). I was looking for a DTS solution because once it is written, running it can be an automated process. But I do agree with you that it's simplier.. even I know how to do that.  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-02 : 12:26:37
|
| BACKUP/RESTORE can be an automated process as well.Tara |
|
|
|
|
|
|
Failed DTS due to user or group not found