PrepAway - Latest Free Exam Questions & Answers

Tag: sql check database integrity task include indexes

What should you do?

You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod containsseveral databases your company uses on a daily basis.
You decide to create a maintenance plan to meet the following objectives:
? The database structure of all databases and indexes on SQL_Prod must be verified.
? All user databases must be backed up before the structure of the databases is verified.
? You must be notified when the maintenance plan has completed.
What should you do?