Post reply

Copy Database Wizard

  • August 11, 2003 at 7:35 am

    #64375

    I am trying to copy a database between 2-SQL2K servers using Copy Database Wizard.

    I am able to configure with source and destination just fine. The package begins to execute and completes with the following error:

    Step Error Source: Microsoft Data Transformation Services (DTS) Package

    Step Error Description:Unspecified error

    Step Error code: 80004005

    Step Error Help File:sqldts80.hlp

    Step Error Help Context ID:1100

    It appears from looking at tasks completed, it creates the share ok, puts db in single user mode, successfully detaches source db and starts the copy. At this point, it fails to copy. Has anyone encountered the same and if so what did you do to correct?

    Thanks........

  • August 11, 2003 at 8:11 am

    #469411

    Checked permissions on the destination machine?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • August 11, 2003 at 8:37 am

    #469418

    What permissions are you refering to?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply