Db Maint supports SQL Server 6.5, 7.0 and 2000. Db Maint also supports MSDE 1.0 (SQL Server 7.0) and MSDE 2000 (SQL Server 2000). Db Maint support all available service packs on mentioned versions, although we do not recommend running SQL Server 6.5 with less than service pack 5a (build 416).

Feature support for different SQL Server versions:

• The "6.5", "7.0" and "2000" columns lists the features in Db Maint 4.0 depending on what version of SQL Server you use Db Maint with.
• The "Db Maint 3.0" column lists the the features in Db Maint 3.0, which is there so you can get a quick overview of the most important new features in Db Maint 4.0.
• The "Maint Wizard" column show the features in the Maintenance Wizard that comes with SQL Server.

General features	6.5	7.0	2000	Db Maint 3.0	Maint Wizard
Operations serialized (one executed directly after the other)	•	•	•	•
Database groups	•	•	•	•
"All" group (with exclude list)	•	•	•	•	• (1)
Daily scheduling	•	•	•	•	•
Hourly scheduling	•	•	•	•	•
Minutely scheduling	•	•	•		•
Reorganization using DBCC DBREINDEX	•	•	•	•	•
Reorganization using DBCC INDEXDEFRAG			•
Consistency check using DBCC CHECKDB	•	•	•	•	•
DBCC CHECKDB using the PHYSICAL_ONLY option			•
Consistency check using DBCC CHECKCATALOG	•	•	•	•
Performance data collection and viewing	•	•	•	•
Pre- and postexecution of TSQL batches, job level	•	•	•	•
Pre- and postexecution of TSQL batches, task level	•	•	•
Warning if low on disk space	•	•	•	•

(1) No exclude list.

Backup	6.5	7.0	2000	Db Maint 3.0	Maint Wizard
Database backup	•	•	•	•	•
Differential backup		•	•
Transaction log backup	•	•	•	•	•
Copy backup files (UNC possible)	•	•	•
Archive backup files (UNC possible)	•	•	•
Generation of original backup files	•	•	•	•	•
Generation of copy backup files	•	•	•
Compression of backup files	•	•	•
Test-restore		•	•
Log shipping		•	•		• (1)

(1) Only available for SQL Server Enterprise Edition.

Logging of executed tasks	6.5	7.0	2000	Db Maint 3.0	Maint Wizard
Log table	•	•	•	•	•
Email using MAPI	•	•	•	•	•
Email using SMTP		•	•
Individually configurable email notification per task	•	•	•
Eventlog	•	•	•	•
HTML	•	•	•	•
SNMP	•			•
Central server	•	•	•	•	•
Printer	•	•	•	•
Generate text file with SQL Server configuration	•	•	•	•
Exclude messages from log	•	•	•	•

Interactive features in the Db Maint client	6.5	7.0	2000	Db Maint 3.0
Backup	•	•	•	•
Restore	•	•	•	•
Consistency check	•	•	•	•
Reorganization	•	•	•	•
View fragmentation level per index	•	•	•	•
View fragmentation for all indexes in database			•
Generate text file with SQL Server configuration	•	•	•	•
View and set database options	•	•	•
User defined menus (add your own TSQL commands to the client)	•	•	•
Space usage dialog for all tables/indexes			•
Map orphaned users to correct login		•	•
Add SQL Server login		•	•