You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following tasks every week: ✑ Rebuild the indexes by using a new fill factor. ✑ Run a custom T-SQL command. ✑ Back up the databases. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

A. A trigger
B. An alert
C. A maintenance plan
D. Windows PowerShell
E. A system policy

  Discussion forum


Leave an answer