Express Helper is a server based solution which empowers an SQL Express installation to perform both maintenance tasks and the execution of custom TSQL stored procedures on a periodic basis.

The core activities of the product are scheduling database backups and support a solid backup recovery model and database tuning to keep you database in peak condition, all with no user intervention to execute the tasks.

Express Helper has three components in a single installation program.

• SQL Server Management Database called Express_Helper
• Windows Service Task
• Express Helper Interface program

Managing backups

Set-up full database backups which cycle through a fixed number of files in the backup set, backups can be set for every day or a particular day and repeat each week.

Performance tune

Schedule regular performance optimisation to re-build indexing, check database integrity and shrink back database files

Executing your own Stored Procedures

If you have your own stored procedures for example to perform regular imports or exports of data, then these can be added to your list of scheduled activities.

Specification

• Schedules full database backups
• Schedules database performance optimisation
• Schedules execution of custom TSQL in stored procedures
• Logs all completed activities
• Provides error logging
• Licensed for a single SQL Server Instance
• Available for SQL Server Express, SQL Server 2005 and 2008
• Requires .net 3.5 Framework
• Priced at £80 + VAT (£94 including VAT) per server instance