Post reply

Error in SQL Copy Database Wizard.

  • April 18, 2011 at 11:52 pm

    #235016

    Hi,

    I am trying to create a copy of Database but getting an error.

    Please let me know the solution. Or let me know if copy of database can be done via script.

    Thanks.

  • April 19, 2011 at 5:23 am

    #1313256

    Indications are, you may have different versions of SQL Server on your client machine and on your server. I'd check that first. You should be able to load SMO. That's a serious problem you're exposing.

    Yes, you can use scripts to copy a database, but it's a lot of difficult work. If you need to do that a lot, I'd look into a good third party tool like Red Gate SQL Compare. But that's not what your problem is. You need to address the SMO issue.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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