March 28, 2002 at 2:15 pm
I try to export the entire database objects from dbA to dbB. While there is login called group1 (it is Window Group) which exists in dbA, but not in dbB. During the "copy SQL Server object" step, SQL Server encounters a problem saying "The login group1 does not exist". And the "export" operation is terminated.
As I can see, there are some other logins which exists in dbA not dbB, but they don't cause problem. Why? Can anyone point me to a direction I can check what is wrong here.
Thank you.
April 1, 2002 at 6:51 am
This usually is related to object permissions, for example if I create a tableA on a server where I have given the select permission to an account UserAcctRead that does not exist on the other server, if I try to export the permissions as well then SQL will bark about the missing account. If you create the account on the other server it will work fine. Or export the tables without including permissions. When using "Copy all objects and data between SQL Server database" you can adjust under "Use default options" uncheck and the button "Options..." I would suggest copy user logins first then do the other items after done.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply