What task types are included in a SQL Maintenance Plan?

You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (Choose all that apply.)

You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (Choose all that apply.)

A.
Back up databases

B.
Defrag hard disks

C.
Rebuild indexes

D.
Copy databases between servers

E.
Update database statistics



Leave a Reply 0

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