Solved

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

Posted on 2016-09-09
3
29 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

Too many email signature updates to deal with?

Do you feel like you are taking up all of your time constantly visiting users’ desks to make changes to email signatures? Wish you could manage all signatures from one central location, easily design them and deploy them quickly to users? Well, there is an easy way!

Join & Write a Comment

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
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…

706 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

19 Experts available now in Live!

Get 1:1 Help Now