hi,
Post by GilbertI am running SQL Express 2005 and I need to install the SQL Server
Agent so I can use it to do backups. How do I do that?
SQL Server Agent is not available in the SQLExpress (both editions) SKU..
for scheduled tasks you have to rely on alternate solutions, usually using
the OS native scheduler, similar to
http://www.sqldbatips.com/showarticle.asp?ID=27 and
http://www.sqldbatips.com/showarticle.asp?ID=29 ..
third party solutions provides an alternate scheduler like
http://www.valesoftware.com/products-express-agent.php (commercial) or
http://www.codeproject.com/KB/database/SQLAgent.aspx (free)..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply