dbTalk Databases Forums  

DTS and Log shipping

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS and Log shipping in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GB
 
Posts: n/a

Default DTS and Log shipping - 12-13-2005 , 05:18 PM






Hello,
I just implemented log shipping on SQL Server 2000 Developer edition
and I need to keep all modifications to DTS packages on Primery Server
to be replicated on Standby Server. Could you please give me a hint how
to do that?

Thanks,
GB




Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: DTS and Log shipping - 12-14-2005 , 03:57 AM






GB wrote:
Quote:
Hello,
I just implemented log shipping on SQL Server 2000 Developer edition
and I need to keep all modifications to DTS packages on Primery Server
to be replicated on Standby Server. Could you please give me a hint how
to do that?

Thanks,
GB



Automate the transfer between the two copies of msdb.dbo.sysdtspackages.
Use DTS to do this is you like.

Some more info here-

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

--
Darren
http://www.sqldts.com
http://www.sqlis.com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.