Solved

Need suggestions for refreshing the latest version of PROD server DTS packages in DR server

Posted on 2016-09-09
3
33 Views
Last Modified: 2016-09-28
Hi there,
  could you point me the best way to refresh the latest version of DTS packages in DR server from Prod server.

As per the various blogs there are many ways we can achieve, but what could be the best and easy practices bearing any issue it would pose or anything i must do pre or post activity?

Please note PROD and DR server are running with SQL server 2008 R2 enterprise edition and the packages are DTS 2000.

Regards
Deepak
0
Comment
Question by:Deepak Kumar
  • 2
3 Comments
 
LVL 78

Accepted Solution

by:
David Johnson, CD, MVP earned 250 total points (awarded by participants)
ID: 41792140
Backup/copy/rename/restore seems to be the best way and it can be scripted.
https://blogs.msdn.microsoft.com/psssql/2009/02/18/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008/

You really should move to SSIS packages though.
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points (awarded by participants)
ID: 41792156
if it is a DR server for your PROD -- backup on prod and restore on DR the msdb database (where we assume DTS stored, unless you keep them in some folder ).
Just do not forget to disable sql jobs on DR server after MSDB restored (it will bring not just SSIS DTS  but, sql agent jobs, etc

more:

 Support for SQL Server 2000 DTS in SQL Server 2008 R2
 https://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx
0
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 41819435
cleanup
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now