What are database maintenance tasks?
What are database maintenance tasks? Database Maintenance is a term we use to describe a set of tasks that are all run with the intention to improve your database. There are routines meant to help performance, free up disk space, check for data errors, check for hardware faults, update internal statistics, and many other obscure (but important) things. How do you do maintenance on a database? The Database Maintenance Plan Wizard will lead you through the following steps:Select databases.Choose the data optimization information options.Choose the database integrity check options.Specify the database backup plan.Specify the transaction log backup plan. What is...