Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Copy Database wizard problem
0 views
Skip to first unread message
Amadelle
Jun 13, 2006, 12:57:01 PM6/13/06
to
Hi all,
I am trying to user the new wizard copy database in SQL 2005 to copy one
database to another server. The task always fails. In the Application
events viewer it reports that it can't generate certain login accounts from
the source to destination db. However, whether I select logins to copy or
not select them to copy I get the same error message. In SQL 2000, I could
user the Export wizard and select that I don't want to copy the permissions
and the logins, and it would get all the other database objects and its data
with relative ease. So what is going on here? What am I doing wrong in 2005
that I can't get the same results?
I am trying to user the new wizard copy database in SQL 2005 to copy one
database to another server. The task always fails. In the Application
events viewer it reports that it can't generate certain login accounts from
the source to destination db. However, whether I select logins to copy or
not select them to copy I get the same error message. In SQL 2000, I could
user the Export wizard and select that I don't want to copy the permissions
and the logins, and it would get all the other database objects and its data
with relative ease. So what is going on here? What am I doing wrong in 2005
that I can't get the same results?
Thanks for your input,
Amadelle
smitha...@gmail.com
Jun 13, 2006, 2:38:22 PM6/13/06
to
Check the following post - perhaps this person can help you...
Amadelle
Jun 14, 2006, 4:23:02 PM6/14/06
to
Mr. Smith that was such a useless help comment.
You just wasted my click time! I knew about that previous post. You just
linked the two of us together, that is not cool.
You just wasted my click time! I knew about that previous post. You just
linked the two of us together, that is not cool.
- Amadelle
0 new messages