Software House: CodePlex
Nome del programma: Expressmaint

Licenza: Microsoft Public License (Ms-PL)

Questo programma esegue la manutenzione dei database MDF gestiti dall’ SQL Server Express Edition versione 2005 o 2008. Le procedure sono basate sull’applicazione SQLMAINT che è disponibile con l’assistente di SQL 2000, ed aggiornate per l’assistente 2005/2008 di SQL.

Da lanciare con gli opportuni parametri come elencati in tabella, mentre alcuni esempi di utilizzo sono disponibili su sito di SQLDBATIPS.

Per la nostra esperienza consigliamo la seguente procedura che mantiene gli ultimi 7 giorni di backup:
expressmaint -S -D -T DB -R -RU WEEKS -RV 7 -B -BU DAYS -BV 7 -V

expressmaint -S -D -T DB -R -RU WEEKS -RV 7 -B -BU DAYS -BV 7 -V

Switch
Argument
Required
Description
-?
N
N
Displays help for the ExpressMaint utility
-S
Y
Y
The SQL Server for ExpressMaint to connect to
-U Y N SQL Authentication Login. If not specified a trusted windows connection is used. If specified a non blank password must be supplied
-P Y N SQL Authentication Password
-D
Y
Y
The target database for the maintenance operation. Valid values are a single database name, ALL_USER which will process all user databases, ALL_SYSTEM which will process all system databases and ALL which will process all databases
-T
Y
Y
The type of maintenance operation to be performed. Valid values are

DB – Full Database Backup
DIF – Differential Database Backup
LOG – Log Backup
CHECKDB – Database Integrity Check
REINDEX – Rebuild all indexes
REORG – Reorganize all indexes
STATS – Update all statistics using default sampling
STATSFULL – update all statics with fullscan
-B
Y
N
The base folder to write the backups to. Sub folders will be created for each database
-V
N
N
Indicates whether to verify the backup file
-BU
Y
N
The unit of measure for the -BV argument. Valid values are minutes, hours, days, weeks. The combination of these two arguments determines for how long old backup files are kept. Required if -B argument is specified.
-BV
Y
N
The time period of old backups to keep. Required if -B argument is specified.
-R
Y
N
The folder where maintenance reports are written to
-RU
Y
N
The unit of measure for the -RV argument. Valid values are minutes, hours, days, weeks. The combination of these two parameters determines for how long old reports are kept. Required if -R argument is specified.
-RV
Y
N
The time period or number of copies of old reports to keep. Required if -R argument is specified.
-A
N
N
Indicates whether to check the archive bit on a backup file before deleting it. This is a safety check to prevent deletion of files that have not been backed up onto tape.
-DS
N
N
If this switch is specified then the timestamp for backup and report files is appended to the front of the filename (the default is to append to the end of the filename)
-TO
Y
N
This switch allows the setting of a statement timeout specified in minutes (e.g. -TO 10). If not specified, the default is 10 minutes.
-C N N This switch allows multi database maintenance operations (ALL,ALL_USER,ALL_SYSTEM) to continue if an error is encountered with one or more databases