Home All Groups Group Topic Archive Search About

Copy Database wizard problem

Author
13 Jun 2006 4:57 PM
Amadelle
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?

Thanks for your input,

Amadelle

Author
13 Jun 2006 6:38 PM
smithabreddy
Check the following post - perhaps this person can help you...

http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/1e8458a9eafbd9be/90ab67f2ffada09d?hl=en#90ab67f2ffada09d

Amadelle wrote:
Show quote
> 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?
>
> Thanks for your input,
>
> Amadelle
Author
14 Jun 2006 8:23 PM
Amadelle
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.

- Amadelle

Show quote
"smithabre***@gmail.com" wrote:

> Check the following post - perhaps this person can help you...
>
> http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/1e8458a9eafbd9be/90ab67f2ffada09d?hl=en#90ab67f2ffada09d
>
> Amadelle wrote:
> > 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?
> >
> > Thanks for your input,
> >
> > Amadelle
>
>

AddThis Social Bookmark Button