Cant shedule backup on SQL 2005 Workgroup. "SQL Agent is not supported"
Posted on 2009-05-04
I need to set up an automated backup procedure for my database, but when trying to "Scrypt action to Job" , I get the error "SQL Agent is not supported on this edition of SQL Server."
I know this is normal for express edition, but we are running the workgroup edition that came with sbs 2003 premium. So far I have not been able to find any documentation to confirm or deny that the error is in fact correct.
Is SQL agent really not supported by 2005 Workgroup edition ? The reason I am doubtfull is that there has been allot of software removal and modification on this server since it was initially set up in 2004, and this MIGHT be some kind of version conflict, or am I mistaken ?
How can I shedule a SQL backup without a intamete knowlige of SQL ?