Cant shedule backup on SQL 2005 Workgroup. "SQL Agent is not supported"

Hi RiteshShah
I think you've hit the nail on the head .. a problem with the services not running. Events in event log show things like :

The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716).

The SQL Server Agent (MSSQLSERVER) service depends on the SQL Server (MSSQLSERVER) service which failed to start because of the following error: The service has returned a service-specific error code.

I'm looking into it now

:) have a look and let me know if you need any help.

Actually I do. When it comes to MS SQL, I dont have much experiance. I can find the files in question in manigement studio, but where is the compressoption that I need to untick ? I'll keep looking in the meantime

Oh I see what went wrong ! Windows compresses a file during disk cleanup if it has not been accessed in a long time. We have not been using the SQL for a while, so the files were NTFS compressed (Show as blue in explorer)

Problem Solved !!

:) good to know that.

OR NOT
Now the services are running fine, the agent is running fine (since I decompressed the files) everything seems ok, but I still get :

TITLE: Microsoft SQL Server Management Studio
------------------------------

Unable to script action to SQL Server Agent job.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

SQL Agent is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.UnsupportedFeatureException&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Any advice ?

have you updated your server with latest SQL Server service pack?

SP2 is installed. As far as I can tell there is a sp3, but that is for Vista. Is sp2 the correct version ?

nothing got clear so far as Author didn't came back so now its up to you A3

Hi Everyone
I am so sorry that I left this question "hanging" I am in fact trying to shedule down time for the server so I can install SP3 for SQL, but currently the client keeps requesting the donwtime be done "later"

The question is open, I am keen to try the solutions and give feed back. You'r patience is appreciated.

Thanks

First off, sorry I took so long to give feedback. I have not been able to shedule the downtime, but I have continued my investigation, and came accross the following.

Even though the server is a 2003 sbs premium box, and I KNOW i installed the SQL work group edition, now when I use " Select SERVERPROPERTY('Edition'), SERVERPROPERTY('ProductVersion'), SERVERPROPERTY('ProductLevel')"
I get " 9.00.3077.00 | sp2 | Express Edition " 

How do I address this issue ? Why is my data running in express edition if I'm supposed to have work group ? Am I right in saying that is why the shedule function on backups in SQL management wont work ?

could it be that you have several sql server instances running?

the output of SERVERPROPERTY is not lying for sure...

There is most definitely more than one instance of SQL running. The 3rd party accounting software was installed by a support agent of the aforementioned software.
 
So Ill have to find a way to migrate the data from one instance to another in order to schedule backups.

Thanks for everyones help.