SQL Server Performance Forum – Threads Archive

DTS transfer from one server to another

Hi, Can anyone help me out in transfering the DTS package from one server to another( Live to Test)? Thanks in Advance,
N.Babu

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

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 —————————————-

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

you have all the information here
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm —————————————-

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by babusamuel 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 <hr height="1" noshade id="quote"></blockquote id="quote"> 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=’

‘ />]

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.

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

I restored it using EM. But still it showed the same error.
N.Babu Don’t try to do different things; Do things differently.

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.

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

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 !!!

]]>