Results 1 to 6 of 6

Thread: Copy Database Wizard

  1. 01-14-2008, 01:45 PM #1
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127

    Copy Database Wizard

    Hi All,

    I am using a Copy Database Wizard to copy SQL 2000 db to SQL 2005. At the Execute SQL Agent Job step I get the following error:

    The directory 'LocalApplicationData' does not exist.

    Any ideas?

    Thanks.
    Reply With Quote Reply With Quote
  2. 01-14-2008, 10:31 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Why don't use backup/restore?
    Reply With Quote Reply With Quote
  3. 01-15-2008, 10:41 AM #3
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127
    I can use that. But then I would have to recreate all jobs and logins. With copy db wizard you don't have to do that.
    Reply With Quote Reply With Quote
  4. 01-15-2008, 09:57 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    No, don't have to. You can copy jobs and logins with ssis tasks.
    Reply With Quote Reply With Quote
  5. 01-16-2008, 08:55 AM #5
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127
    Good idea. I'try that. Thanks.
    Reply With Quote Reply With Quote
  6. 01-16-2008, 10:56 PM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    The reason I don't use copy db wizard is that it detaches source db.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules