Post reply

Copying Databases - single user mode needed ?

  • October 19, 2003 at 1:43 pm

    #106461

    I've created a simple DTS package to copy a database from one SQL 7 Server to another - it keeps failing. Does the db have to be in single user mode or something ? How can I encorporate this into my dts job which I need to schedule to run overnight ?

  • October 21, 2003 at 2:41 pm

    #479003

    Which error do you get? Are you using the Copy Database Wizard or the Copy SQL Server Objects Task?

  • October 22, 2003 at 4:15 am

    #479051

    I get this error :

    DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Transfer SQL Server Objects DTSRun OnError: Transfer SQL Server Objects, Error = -2147206103 (80043C29) Error string: Error source: Help file: Help context: 0 Error Detail Records: DTSRun OnFinish: Transfer SQL Server Objects DTSRun: Package execution complete. Process Exit Code 1. .

    Running the copy objects.

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

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