Error Copying Database between servers

[jhixson]

We are trying to copy a database from our testing server to our production server. When we use the Export / Import Wizard we get an error saying "[Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'CC\esis' not found. Check the name again." We log into our network as ourselves and the name of the database we are trying to copy is ESIS but I do not understand why it is saying the database should be a user or group. Can anyone shed some light on this problem?

Thanks,

John

 

[ecobb]

I've run into problems when trying to Import/Export database tables. I've seen several hundred records get deleted this way. You'd be better off to just backup your database and restore it on the production server if you're trying to copy the whole database.

Hope This Helps!

Ecobb
- I hate computers!