Post reply

copy database

  • March 17, 2007 at 10:24 pm

    #153482

    I am trying to copy a database from sql 2000 to sql 2005. I used the copy database feature and followed the instructions to the letter. When the SSIS package run, it fails. It tells me to check te error log, but it doesn't explain why it's failing. Please help me find why. I'm told that I can use backup and restore to achieve the same task but I can't find out the steps to do this. Please help

    Thanks

  • March 18, 2007 at 3:15 pm

    #695615

    There's a virtual lab available from Microsoft that covers this situation. I believe it's free, you just have to put up with a follow-up call from Microsoft. The lab should contain detailed instructions and it'll give you a chance to go through the steps in a completely safe environment:

    http://go.microsoft.com/?linkid=4872480

     

    K. Brian Kelley
    @kbriankelley

  • March 19, 2007 at 2:18 am

    #695645

    Hi Jennifer,

     

    Could you give us the exact error message, or some additionnal informations so someone could help you.

  • March 19, 2007 at 11:10 am

    #695774

    That's just it; when I execute the ssis package, it doesn't run or give me a reason why.

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

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