Maintenance Tasks To begin a new maintenance task, follow the instructions above until the SQL Maintenance Task dialog box has been reached. Choose a maintenance tasks using the drop-down menu. • Data Aging Tasks • Set Database Recovery Model • Truncate the Transaction Log • Shrink Data and Log files