I couldn't import a database from sql2k to sql05 because toward the end of
the import it would error. problem is it didn't provide any useful
information. I ran the best practice analyzer utility on the sql2k db but
didn't find anything that should make it crash when coping the data over.
So I detached the mdf and ldf files from the 2k db and attached them in the
05 server. Things seem to be OK. I ran a maintenance plan to clean things
up a bit, then tested exporting this new 05 db to a new 05 db on the same
server just to see it I could finally run a dts on it. It made it through
all the steps OK, but on the last one it said:

Action = Copying To
Status = Stopped

Does Status = Stopped mean it didn't finish coping? or does it mean it
finished coping all the data?

Thanks.

Hello,

Yes. Stopped means it didn't finish copying due to some issues. You shall
click message on the right for more details about this error. If it is
copying data successfully, status shall be "success".

You may want to run "dbcc checdb" to check the source database. Also,
please try to copying a small table from source database to test. You could
try to create a new table and insert some records, and then copy the table
by using importing wizard.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.