SQL Server Agent vs. SQL Server service???

[JennyPeters]

What's the difference between the SQL Server Agent service, and the SQL Server service?

Is one better than the other?

Thanks,

Jenny

 

[JamesLean]

The SQL Server service is the actual SQL Server itself. This has to be running to be able to do anything with the server itself.

SQL Server Agent mainly takes care of scheduled tasks but has other functions, eg automatically restart the main SQL service if it stops unexpectedly.

BOL contains full information on both of these, plus the other services that SQL Server can use.

--James

 

[JennyPeters]

Thanks James. That makes sense.

This may sound like an odd question, but what is BOL?

Jenny

 

[JayKusch]

Books OnLine

Thanks

J. Kusch

 

[JennyPeters]

It's always something simple!

Thanks,

Jenny

 

[SQLBill]

The Books OnLine are usually found at:

Start>Programs>Microsoft SQL Server>Books OnLine

-SQLBill