Thank you Antares for your explanation. I think this is the reason for my problem. Thank you Allen also, your example is for advanced server. that 3 GB is assighned...

System error didn't show anythins else. the application log error showa: Error accepting connection request via Net-Library'SSNETLIB', Execytion continuing.

I also doubt it's not the memory problem, it must be related...

Thank you all.

When the jobs failed, the available memory is about 1.5 GB.

I am running on sql2k 8.00.679 that is sp2

plus latest security patch.

For a standard sql server, can it...

After the transaction log file reduced, then I change the option to 'full' immediately, and do the transaction log back up.

Thank you Brendon for your explanation.

Robert

...

One possible reason for this is the server is too busy, Besides SQL, maybe some other applications on the server. If so, you'd better

move some applications or update your hareware....

Hi Brendon,

Thanks for your reply.

I set up the option 'full' and backup the trans log file every hour for years. This is our main server, everyday...

Hi all,

I got a sql2k server, for some reason the trans log file grows to 92 GB, I did dbcc shrinkdatabase (dbname, truncateonly). As respected, the trans log...

Thank you very much, Allen.

I checked the history, there is no error

shown. Next time I will kill the job from

task manager.

Thank you again.

...

Yes, sometimes the optimizing job and integrity job will run endlessly as well.

Robert