Monitoring Databases  «Prev  Next»

Develop Database Maintenance Plan - Exercise

Develop Database Maintenance Plan

Objective: Given specific conditions, write a SQL statement to effectively monitor a database.

Exercise scoring

This exercise is worth a total of 10 points. To receive full credit, you will need to review the scenario and write your ideas for a database maintenance plan in the text box below. Once you have completed your answer, press the submit button.


As the system administrator for the XYZ Rental Corporation, you need to develop a database maintenance plan for the Sales database.
  1. A full database backup takes four hours and you only have time to do it once a week.
  2. A transaction log backup takes 20 minutes.
  3. You expect that your data distribution will significantly change over a three week period.
  4. All tables have autostats turned on.
  5. You only want to perform backups if the database is not corrupt.
  6. You want to backup files to disk.
  7. You want the reports to be emailed to JoeSmith.
  8. You will also want to view the reports from your Internet.
  9. You will use integrated security.
  10. You need to be able to recover up to the minute.


Construct the sqlmaint statements that will generate the desired maintenance?

Submitting your exercise

Enter your answer into the text box below. Click the Submit Button below to submit the answer.