Post reply

Copy database

  • April 25, 2004 at 3:37 pm

    #108286

    Failed to create shared OMWWIZD. I have used this once before on this server and it worked fine. I'm using an account that has rights as admin on the local box, member of sysadmins and the SQL agent account. Any ideas?

  • April 27, 2004 at 2:11 am

    #504290

    There's an article on MSDN with this error:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;274463

    In summary it says if the destination server is started with the Local System account, or an account that does not have local admin rights on the source then this error will occur.

  • April 27, 2004 at 8:15 am

    #504336

    Thanks, I read the article, we aren't using the Local System Account we're using a domain account that has rights as a local admin, on the network, and as the sql agent

  • April 27, 2004 at 8:29 am

    #504343

    Try using BACKUP from the source and RESTORE on the destination then.  It doesn't transfer Jobs, Errors, objects in master or logins, but it does work.

  • April 27, 2004 at 8:35 am

    #504345

    I did that yesterday. I'm still hoping that I (or someone else) can figure out how to make the copy database procedure work.

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

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