Question description

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.
OR

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 

Published by
Ace Tutors
View all posts