SQL Server Performance

DTS transfer from one server to another

Discussion in 'SQL Server DTS-Related Questions' started by babusamuel, Aug 18, 2006.

  1. babusamuel New Member

    Hi,

    Can anyone help me out in transfering the DTS package from one server to another( Live to Test)?



    Thanks in Advance,
    N.Babu
  2. ranjitjain New Member

    Hi, this has been discussed here before many times.
    Please search for similar threads here.
    Also read about structured storage files in DTS.
    If your test server is accesible from live then,
    open DTS on live in designer.
    click on save as and enter all test server details and save.
    DTS will be copied from live to test, else read about structured storage files in BOL
  3. dineshasanka Moderator

    you cna transfer msdb db to get all the dts. but it will over wirte dts in Test server.
    safest method is ranjit's method

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

  4. babusamuel New Member

    Thanks for your reply. In my scenario, the easiest method is to backup and restore the msdb database. Because I want to move the package to a new server.



    Thanks,
    N.Babu
  5. dineshasanka Moderator

  6. ranjitjain New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by babusamuel</i><br /><br />Thanks for your reply. In my scenario, the easiest method is to backup and restore the msdb database. Because I want to move the package to a new server.<br />Thanks,<br />N.Babu<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Also read about structured storage files for DTS to move packages to new server which i had mentioned in my first post as well.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  7. babusamuel New Member

    when i tried to restore MSDB database in the new server i got the following error:-

    Cannot restore database, database is in use.


    when i looked into the Enterprise Manager, it is showing my user name only and no other users are connected to the database.

    Can anyone explain why this error occurred?







    N.Babu

    Don't try to do different things; Do things differently.
  8. ranjitjain New Member

    are you restoring the same from enterprise manager or QA.
    also if QA are running the command under master database.

    ITs like: dropping the database by making connection to it.
    You can't
  9. babusamuel New Member

    I restored it using EM. But still it showed the same error.






    N.Babu

    Don't try to do different things; Do things differently.
  10. babusamuel New Member

    Let me explain the scenario:


    I took the backup of msdb database from one server(Server1) and I disconnected that server (server1) from the network. The backup files are moved to another shared path. Then I connected Server 2 and tried to restore the msdb database. At that point of time I faced this error.





    N.Babu

    Don't try to do different things; Do things differently.
  11. ranjitjain New Member

    i think you need to run SQL server in single user mode, and then you will be able to restore.
  12. patel_mayur New Member

    Try to restore after stopping SQL Server Agent if its running. Make sure you dont click on meta data service node in EM.




    Knowledge is not Power !!!
    But When its acted upon then its Power !!!

Share This Page