Why not try setting up replication, but setting up the distribution + agents on the subscriber with a pull subscription.
The way the box from which you want to move the data will only have a publication entity on it.

This should minimise performance impact because the bulk of the work will be done on the target not the source.

-----Original Message-----
From: Femi George [ MTN - UBA ]
[mailto:mssqldba-ezmlmshield-x8832671.[Email address protected]
Sent: 26 November 2004 08:10
To: LazyDBA Discussion
Subject: replication on a very sensitive sql server



can anyone suggest how to move data away from a very sensitive sql server
2000?
the application runs several transactions and any extra load on it tends to
affect its performance.

the data is to be moved away for data warehousing purposes...i thought of
replication but would that not put extra load on my transaction sql server?
is there a way to do replication at the OS level?
Thanks..any suggestions?
Femi George
Enterprise Data Warehousing [MTN-AGIP]
[Email address protected]
08032090305



NOTE: This e-mail message is subject to the MTN Nigeria disclaimer see
http://www.mtnonline.com/contact/disclaimer.asp


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept for the presence of computer viruses but this in no way indicates that the message is virus free.
**********************************************************************


MS Sql Server LazyDBA home page