Thanks for the help.
But i have a question that i had never done this before. Can you tell me the steps if so.(snapshot replication and copy database)
Also the database i want to copy in local server have to be copied some particular tables , there are around 80 tables , in which 20 tables need to be moved in the local server
And then i can use snapshot replication.
I was trying to copy the database but it was allowing me copy the full database not letting me select particular tables from that database