Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What is the "sqlexecutive" process?

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

Is it somehow connected with mssqlagent?

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

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted

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.

share|improve this answer
    
I found it in some old backup script as a service name –  Darqer Oct 12 '10 at 15:11
    
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. –  RobM Oct 12 '10 at 15:13
    
OK, thank you very much –  Darqer Oct 12 '10 at 15:43
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.