I have Microsoft SQL Server with 30GB of database and there are several DB Maintenance plans:
DB Maintenance Plan 1: It performs Optimization (runs 1am daily) and Integrity Checks (runs at 9:30pm daily).
DB Maintenance Plan 2: It backs up main SQL database to the shared folder off another PC on the network (runs at 10pm daily).
Transaction Log Backup: It backs up TRN files to the shared folder off another PC on the network every 30 minutes throughout the day.
1. What does Optimization and Integrity Checks?
2. Do they have to run Daily?
3. Between Database backup, Optimization and Integrity Checks, what should be the right order of running these jobs as far as scheduling goes?