Points worth noting -
For Backup/Restore
1> As the databases are on the same server, the necessity for moving data is not there. But, in future, if you plan to move the secondary database to any other system, network issues effect the process.
2> Each time you restore, scripts has to be run to take care of orphaned users.
For Replication
1> For transactional replication only the changes are migrated
2> All the tables for replications have to have a primary key.
3> You can have reporting services running on the replicated database
For Log shipping
1> Only the change move through the network (if on separate servers)
2> Reporting services cannot be setup
Copy database
1> Not recommended
There are other techniques using scripts and logic......which are tidious, time taking and needs thorough testing, but worthy enough
SP + SQL Job
Trigger
Hope this helps......
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.