- Open up SQL Server Management Studio
- Connect to Server 1 (the database you want copied)
- Expand the server folder structure you will see Replication
- Expand the replication folder
- Rght click and create a new publication under Local Publications
- Once complete you can configure the distribution by right clicking on the replication folder
- Connect to server 2 (where you want the database copied)
- Under the replication folder if it has not already created a subscription to the publication on Server 1 create it.
Creating a linked server should only be used if you need to do cross server queries.
If he just wanted to copy the data fresh everytime you could just setup a dts job that runs x number of times per day.
The option is up to you. The replication will be faster because it will transfer less data. DTS will be the whole package everytime.