Assessment Brief

All references and citations must be in APA format1. You want to back up the transaction log of your database every hour during peak business hours and every four hours during nonpeak hours.  How would you accomplish this ?2.  List all parts of a SQL Server error message.3.  Why do you need a primary key for data replication ?  Which replication type requires a primary key ?4. When does the system use the Log Reader agent, the Merge agent, and the Snapshot agent respectively ?  (detailed answer)