Which two tasks should you include in your design?

You administer a SQL Server 2008 infrastructure.
Your company requires capacity planning information.
You need to design a long-term infrastructure monitoring strategy.
Which two tasks should you include in your design? (Each correct answer presents part of the solution.
Choose two.)

You administer a SQL Server 2008 infrastructure.
Your company requires capacity planning information.
You need to design a long-term infrastructure monitoring strategy.
Which two tasks should you include in your design? (Each correct answer presents part of the solution.
Choose two.)

A.
Backup all databases every day.

B.
Clear the system log and the application log every hour.

C.
Review system monitor counters on a regular basis.

D.
Baseline the system before you deploy production databases.

E.
Create a maintenance plan that rebuilds indexes every week.



Leave a Reply 0

Your email address will not be published. Required fields are marked *