April 19, 2004 at 1:24 pm
I have a new sever that is running SQL 2000(b) and the old is running SQL 7.0(a). I've used the copy database wizard to copy my database from (a) to (b) with no problems. I have since deleted the database on (b) and tried to run the copy again from (a) to get additional logins that errored out the first time. I receive the Step error code: 80004005 now each time I try to run the wizard. Permissions are the same on both servers and instances of SQL (using a domain id with admin rights to the boxes). Any help would be appreciated.
April 19, 2004 at 1:37 pm
Did you drop the logins from server (b) before retrying the copy?
April 19, 2004 at 1:43 pm
No I didn't. Is that required and if so, are there other objects I should remove before trying again?
April 19, 2004 at 1:55 pm
It depends on what you are including in the database migration. Check your logins and check that you have removed the database if you are going to import the whole thing again.
April 19, 2004 at 2:07 pm
I'm bringing over only the id's associated with that specific database and taking all the other defaults options given.
April 19, 2004 at 3:17 pm
Is there a script that I can run to remove all 2800 logins at once?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply