We have below options in the Maintenance Wizard.

1. Check Database Integrity – checks the logical and physical integrity of all objects in the database

2. Shrink Database – shrinks the files and the logs in the specified database on a file-by-file basis. It pools log files. Physically shrinking makes the file smaller and truncates a file in the backup.

3. Reorganize Index – uses minimal system resources and defragments indexes of tables and views by reordering the pages to match the logical order

4. Rebuild Index – drops and recreates the index reclaiming space and reorders the index rows in contiguous pages

5. Update Statistics – updating statistics ensures queries run with up-to-date statistics, but they also require queries to be recompile, can result in a performance trade-off

6. Clean Up History – deletes entries in the history tables

7. Execute SQL Server agent job – Windows service that runs scheduled jobs

8. Backup Database (Full) – Backs up the entire database, but as databases grow, the backup takes longer and requires more storage. The best solution is to use in conjunction with differential backups.

9. Backup Database (Differential) – used to back up only the data that has changed since the last full backup

10. Backup Database (Transaction Log) – used to back up individual transaction logs, which can be individually restored since the last full backup

11. Maintenance clean up task – performs housekeeping functions