Post reply

copy database wizard

  • September 13, 2004 at 6:40 am

    #161524

    hello guys,

     

    first of all sorry for my poor english

    I want to use the copy database wizard to copy database,logins jobs etc from one server to another.

    the first server is a win200 server with sqlserver 7 and the second a win2003server with sqlserver 2000.

    I start the wizard on the second server, type the ipadres from the source server and sql authentication, then the destination, the database that I want to copy (52 database), logins, jobs, stored procedures etc and then I have the following error :

    Step Error Source: Microsoft Data Transformation Services (DTS) Package

    Step Error Description:Unspecified error

    Step Error code: 80004005

    Step Error Help File:sqldts80.hlp

    Step Error Help Context ID:1100

    Clicking on the "MRE INFO >>>" button, you will find that permissions to create the remote share are not present.

    Failed to create the share OMWWfIZD
     
     
    I have connection with the source server because  I can see all the database on the source server but when I want to transfer it doesn't work.
     
    can someone help me please?

  • September 14, 2004 at 11:36 am

    #523017

    DTS packages always had a problem.

    Try a simple backup database for all database ( using maintenance wizards )

    and restore it in the second server.

     

    You can transfer logins using DTS package for master and msdb databases.

     

    In the restored database , usinge sp_change_user_logins auto_fix,<login_name>  for each login for each database to equalize logins ID.

     

    Hildevan


    Hildevan O Bezerra

  • September 14, 2004 at 3:26 pm

    #523071

    You'll get that error message if the destination SQL Server is started under a domain account that does not have local administrator privileges on the source computer.  

    "Failed to create the share OMWWfIZD" means that the account doesn't have permission to create the remote share.

    Greg

    Greg

  • October 1, 2004 at 10:34 am

    #525060

    Yes Greg. Its´s true.

     

    But , for answer the best and more simple way, I use a backup and copy database.

     

    If you´ll have a server in different domains , you can backup all databases via backup wizard from Server A to a local disk.

     

    After that, you que tranfer via share to another server and perform a restore.

     

    Another way is a shutdown both servers and copy all databases to another sql server and startup again.

     

    In this case , you can perform a same instalation of SQL Server in secondary server , using same directory structure.

    After you startup the secondary server , go to Query Analyser and execute :

     

    sp_dropserser "<primary_server>"

    go

    sp_addserver "<secondary_server>".

     

    Good luck.

     

     

     


    Hildevan O Bezerra

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

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