I have followed the link below
http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/ and I can create SQL Server Replication Snapshot Bulk-copy Data File, SQL Server Replication Snapshot Index Script, SQL Server replication Snapshot Script, Sql Server Replication Snapshot Schema Script. However on a failure condition how do I connect the data to the Replication files so the database is looking into the replication folder.
I guess I am having issues understanding the steps required to perform transactional replication. Just now I learned that Replication are of two kinds Transactional and Merge Replication. Do you know of a good article that I can follow to learn and implement replication.