moving data away from a very sensitive server

[eja2000]

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?
thanks..any suggestions?

 

[johnv20]

Since any operations will put extra load on the server you're going to have to bite the bullet anyway - probably youre best bet is to ship the transaction logs to the data warehouse

 

[eja2000]

u mean log shipping?

 

[johnv20]

Yep - replication means changing the database schema , DTS is dodgy at best ,I find that log shipping is the most reliable method with the least overhead.