Solved

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

Posted on 2016-09-09
3
50 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 81

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 43

Assisted Solution

by:Eugene Z
Eugene Z 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 81

Expert Comment

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

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

732 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