asked on Need suggestions for refreshing the latest version of PROD server DTS packages in DR server
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
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
Microsoft SQL ServerWindows Server 2008
Last Comment
David Johnson, CD
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
cleanup