ExpressMaint utility for SQL Server Express

Seeder question:

I have a client who has SQL Server Express 2005 installed, and is using a command line utility called 'expressmaint'. I can't find any reference to this in BOL. What is it?

asked Oct 26 '09 at 02:37 PM in Default

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

(comments are locked)

2 answers:

The "Express" versions of SQL Server (2005 and beyond) do not include SQL Agent for performing automated backup and maintenance tasks.

expressmaint is two part open source utility maintained by Jasper Smith and designed to be used with the Windows Task Scheduler to provide automated backup and maintenance tasks which would normally be provided via the SQL Agent. It can also be used interactively from a CMD prompt or batch file.

The first part of the utility is stored procedure to be called via SQLCMD and the other part is a Visual Basic console application that uses SMO to provide the same functionality as the stored procedure version.

answered Oct 26 '09 at 10:22 PM