What is sqlexecutive in MS Sql

Hello

What is this: sqlexecutive process.

Can I run it under sql2005 or sql2008, is it available in sqlexpress version ?

Is it somehow connected with mssqlagent.

When I want to create backup of DB shoud I care about stopping it?

From serverfault Darqer

• Where did you hear that term? (The context you heard it in may help understand what you're asking). IIRC it's an old MS SQL Server component, I don't even think its part of any modern version of SQL Server.

  In any case, you shouldn't be stopping any SQL Server components to back up SQL Server databases - use either a SQL Server aware backup process or use the backup routines available in SQL Server itself to create a backup file, then backup that file.

  Darqer : I found it in some old backup script as a service name

  Robert Moir : Then I'd say its the old component that I'm thinking about. Not relevant in SQL 2005/2008. As I say though you shouldn't be stopping services as part of a SQL Server DB backup anyway.

  Darqer : OK, thank you very much
  From Robert Moir

• SQLexecutive was one of the pre-SQL Server 2000 services used for managing scheduled tasks and alerts.

  You may have seen it in a few older scripts if backups were set to be performed by NT server Administrator Tools (instead of SQL server). Part of that would involve stopping and restarting the SQL services: mssqlserver & sqlexecutive Here's more info.

  The only way this would still be relevent is if you were running SQL Server 6.5 or 7

  From shiitake