I have sql2000 database on a webhosting server. i want to schedule the replication of database on server to my local machine . how can i do that ? please help me with step by step guide.. i am not too familiar with replication
We dont have a step by step guide here on the site yet, you may find one at the MS site. First thing you have to decide is which type of replication. Snapshot or transactional are both pretty easy to implement.