1. Explain the importance of database automation. What database processes are likely candidates for automation and why? Detail three processes that would be candidates for automation and why.
Explain in detail the SQL Server recovery models. What are the reasons for selecting a specific recovery model?
2. 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?
3. List all parts of a SQL Server error message.
4. Why do you need a primary key for data replication? Which replication type requires a primary key?
5. When does the system use the Log Reader agent, the Merge agent, and the Snapshot agent respectively? (detailed answer)
No Plagiarism, need APA format