Copy Database Wizard

I am attempting to use the CDW, to copy a database on my
laptop running SQL server 2000 PE to a server running SQL
Server 2000 standard edition. I think that I have set
all of the appropriate permissions/authentications etc.
I have run it both from EM and the command line but it
fails to copy the source .mdf file. All other function
execute properly ie the share is created, single user
mode invoked, etc etc. I have tried changing the name of
the destination file etc and it still results in a
failure to copy the source file error. Is this yet
another limitation of the PE or am I not doing something
correctly?
Thanks
The copy database wizard uses detach, copy and attach, and there aren't any
issues going up a version that I know of (going down is different if EG you
used partitioned views then downgraded to Personal Edition):
http://www.winnetmag.com/Articles/Ar...91/pg/2/2.html
http://support.microsoft.com/default...;en-us;q268361
Can you try detaching manually, making a copy of the file, copying the file
over to the share on the EE then attaching manually.
Hopefully this should establish the point of error.
HTH,
Paul Ibison
|||Will give it a try, thanks
>--Original Message--
>The copy database wizard uses detach, copy and attach,
and there aren't any
>issues going up a version that I know of (going down is
different if EG you
>used partitioned views then downgraded to Personal
Edition):
>http://www.winnetmag.com/Articles/Ar.../21391/pg/2/2.
html
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q268361
>Can you try detaching manually, making a copy of the
file, copying the file
>over to the share on the EE then attaching manually.
>Hopefully this should establish the point of error.
>HTH,
>Paul Ibison
>
>.
>
|||That worked, thanks[vbcol=seagreen]
>--Original Message--
>Will give it a try, thanks
>and there aren't any
>different if EG you
>Edition):
..
>html
>us;q268361
>file, copying the file
>.
>