We would like to create a copy of an existing datbase and refresh the database once a day(may need more frequent updates at a later date). We want both databases to reside on the same server. The initial thought was to use replication.
1. What other options are available?
2. Is replication the best tool to accomplish the copy?
3. If so, can we replicate on the same server?
4. Is snapshot replication the best replication type for the copy?
Jeff
jchie@vafb.com