Bienvenu(e)! Identification


il faut ajouter le paramètre -TO 30 pour un timeout de 30min par défaut il est de 10min :)

"Backup failed for Server 'MYSERVER\SQL2008EXPRESS'.
An exception occurred while executing a Transact-SQL statement or batch.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The backup or restore was aborted."



L'utilitaire ExpressMaint s'installe le plus simplement du monde : on extrait le fichier ExpressMaint.exe et on l'enregistre dans le répertoire de son choix ! Le fichier fait environ 60Ko : le fonctionnement de cet outil nécessite l'installation du .NET Framework (généralement installé en même temps que Sql Server). Pour la dernière version, il faut la version 3.5 (ou plus) de .NET
Paramètres et arguments :
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
-BF Y N This switch allows specifying custom backup filename formats. Accepted tokens are $(DB) for database name, $(DATE) for current date, $(TIME) for current time and $(OPTYPE) for backup type
Seuls les utilisateurs enregistrés peuvent poster des messages dans ce forum.

Cliquez ici pour vous connecter