Minion Maintenance 1.1

Minion Backup by MidnightDBA is a comprehensive database backup solution for SQL Server that simplifies and automates the backup process. Key features include:

1. Live Insight - Monitor the progress of your backups in real-time, with visibility into the percent completion for each task.
2. Dynamic Backup Tuning - Configure thresholds and adjust settings dynamically based on your requirements, even down to specific times of day.
3. Extensive File Management - Stripe, mirror, copy, move, and delete backup files without additional jobs, with the ability to archive files to prevent deletion.
4. High Availability and Disaster Recovery (HA/DR) Awareness - Synchronize backup settings and logs across Availability Group nodes, mirroring partners, and log ship targets.
5. Single-job Operation - Manage complex backup scenarios effortlessly with a single job, eliminating the need for multiple job configurations.

Minion Backup ensures reliable, flexible, and efficient database backups, making it an essential tool for any SQL Server environment.

Minion CheckDB

Minion CheckDB is an advanced database integrity check module for SQL Server that automates and optimizes database consistency checks. Key features include:

1. Dynamic Thresholds - Automate DBCC CheckDB or DBCC CheckTable operations based on customizable thresholds.
2. Remote CheckDB - Run DBCC CheckDB remotely for any database, with dynamic tuning thresholds to optimize performance.
3. Custom and Dynamic Snapshots - Create custom snapshots for versions of SQL Server that support them, with the option for rotating snapshots for CheckTable operations.
4. Multithreaded Processing - Perform multiple DBCC CheckDB and CheckTable operations in parallel, significantly reducing total check time.
5. Rotational Scheduling - Define rotation scenarios to distribute integrity checks over multiple nights or limit operations by time.
6. Extensive Logging - Utilize the Minion CheckDB log for detailed insights, troubleshooting, planning, and reporting.
7. Flexible Configuration - Include or exclude specific databases, schemas, and tables using names, LIKE expressions, and regular expressions.
8. Automated Installation - Easily roll out Minion CheckDB to hundreds of servers with minimal effort.
9. Live Insight - Monitor the progress of CheckDB operations in real-time, with visibility into the percent completion for each task.

Minion CheckDB ensures thorough, efficient, and flexible database integrity checks, making it an essential tool for maintaining SQL Server database health.

Minion Reindex

Minion Reindex by MidnightDBA is a powerful index maintenance module for SQL Server that automates and optimizes index management. Key features include:

1. Automated Operation - Simply run the installation scripts, and Minion Reindex will automatically manage your index maintenance.
2. Easy Mass Installation - Install on hundreds of servers as effortlessly as on a single one.
3. Granular Configuration - Configure settings at the default, database, and table levels without the need for multiple jobs.
4. Reindex Ordering - Reindex databases and tables in the specific order you require.
5. Flexible Include and Exclude - Target only the databases you want using specific names, LIKE expressions, and regular expressions.
6. Live Insight - Monitor the progress of reindexing operations in real-time, with visibility into the percent completion.
7. Maximized Maintenance Window - Optimize your maintenance window by spending it on index maintenance rather than gathering fragmentation stats.
8. Extensive Logging - Utilize the Minion Reindex log for detailed insights, troubleshooting, planning, and reporting.
9. Built-in Manual Runs - Print reindex statements and run them individually as needed.
10. Integrated Help - Access help for any Minion Reindex object directly within Management Studio.

Minion Reindex ensures efficient, flexible, and comprehensive index maintenance, making it an essential tool for optimizing SQL Server performance.