copy database error

  • Hi ,

    I am trying to copy a app database from sql 2000 to 2008 for testing purposes. But the package created by copy database wizard is failing.

    Can anyone help?

  • thats the least reliable method of trying to copy a database. Any reason why you cannot use backup\restore?

    ---------------------------------------------------------------------

  • The new server that I am doing migration on has to be tested.

    So the app owner wants the database to be copied and not restored. So I do not have a choice.

    Thanks

    SVR

  • I'm not sure I understand. What difference does it make to the app owner how you get the database to the new server?

    John

  • I am given specific steps to follow. I do not know why he wants that to happen.

  • I'm guessing neither does the app owner. 🙂

    the end result would be the same

    ---------------------------------------------------------------------

  • I guess so:-)

  • its communcation prob! he comes to me and says you can restore the db , no need to copy the db!!!!!

  • SVR (7/12/2011)


    I am given specific steps to follow. I do not know why he wants that to happen.

    Seems if he was that specific, he'd know how to fix the problem you're having. 😉

    Are you allowed to detach/copy mfd/attach?

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

  • it is all resolved. he came and told me to just use restore.

    Thanks

    SVR

  • I had the same problem And cant resolve it until now.

  • What did the business owner say? did that person contact the vendor and try to resolve? I will let you know if I have any progress.

Viewing 12 posts - 1 through 11 (of 11 total)

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