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?

more ▼

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

Kev Riley gravatar image

Kev Riley ♦♦
50.8k 43 49 76

(comments are locked)
10|1200 characters needed characters left

2 answers: sort newest

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.

more ▼

answered Oct 26 '09 at 10:22 PM

KenJ gravatar image

19.1k 1 3 11

(comments are locked)
10|1200 characters needed characters left
more ▼

answered Oct 26 '09 at 03:36 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 76 79 82

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 26 '09 at 02:37 PM

Seen: 3648 times

Last Updated: Oct 26 '09 at 02:37 PM