Solved

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

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

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 80

Expert Comment

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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

829 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