question

Log shipping works by moving the transaction log from one place to another. It basically works through the backup/restore technology. Replication works one of three ways, through snapshots, which is almost like a backup & restore, but not exactly, that copies an entire database. Through transaction replication which takes each transaction and transmits that. Finally through Merge replication which marks changes from multiple locations and moves them back and forth between each other. This works through a different set of technology that requires you to define publishers, subscribers and distributors which manage the connections between the other two. This is all easily found by reading [SQL Server Books Online][1] Is this an interview question? [1]: http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CB8QFjAA&url=http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms130214.aspx&ei=FNXLTteQO8Hg0QH7yekr&usg=AFQjCNEhybBatrE8nium44Q0-2MF8LMFqg&sig2=wn4ZU3Zrpm3sfD6ie6yA8Q