dp-300-database-admin-assoc video for typical activities that you can schedule for regular SQL Server maintenance include: Database and transaction log backups
Typical activities that you can schedule for regular SQL Server maintenance include: Database and transaction log backups Database Consistency Checks Index maintenance Statistics updates Maintenance plans also allow you to specify that older database backups should be removed from disk. Removing old backup files helps your SQL Server by reducing the size of your backup volume and helps manage the size of the msdb database. Ensure that your backup retention period is longer than your consistency check window. This means if you run a consistency check weekly, you should retain eight days of backups. True or False: This practice is highly critical as the backup operation will detect corruption in a database.