patternMinor
SQL Server 2008 R2 Express for a single website?
Viewed 0 times
websiteexpress2008sqlsingleforserver
Problem
Someone recently told me I could use SQL Server 2008 R2 Express edition for a single website. But don't you need the Server Agent for connections (I think. I'm trying to remember things from over several years ago now!) and Express has it's Server Agent disabled?
Solution
You do not need the SQL Server Agent. It has nothing to do with database connectivity.
http://msdn.microsoft.com/en-us/library/ms189237.aspx
SQL Server Agent is a Microsoft
Windows service that executes
scheduled administrative tasks, which
are called jobs. SQL Server Agent uses
SQL Server to store job information.
Jobs contain one or more job steps.
Each step contains its own task, for
example, backing up a database. SQL
Server Agent can run a job on a
schedule, in response to a specific
event, or on demand. For example, if
you want to back up all the company
servers every weekday after hours, you
can automate this task. Schedule the
backup to run after 22:00 Monday
through Friday; if the backup
encounters a problem, SQL Server Agent
can record the event and notify you.
http://msdn.microsoft.com/en-us/library/ms189237.aspx
SQL Server Agent is a Microsoft
Windows service that executes
scheduled administrative tasks, which
are called jobs. SQL Server Agent uses
SQL Server to store job information.
Jobs contain one or more job steps.
Each step contains its own task, for
example, backing up a database. SQL
Server Agent can run a job on a
schedule, in response to a specific
event, or on demand. For example, if
you want to back up all the company
servers every weekday after hours, you
can automate this task. Schedule the
backup to run after 22:00 Monday
through Friday; if the backup
encounters a problem, SQL Server Agent
can record the event and notify you.
Context
StackExchange Database Administrators Q#1956, answer score: 6
Revisions (0)
No revisions yet.