sp_who2 will also give information on who is tracing .

It seems there are some users with sysadmin privileges in your database.

Not sure how your environment is set up,but...

Thanks for your response

The intention was to move it from restoring ,read only then back to restoring so it is in restoring and not in read only...

I believe if you take a full backup a transaction log backup will be the changes after the full backup which you probably do not need.

Fortunately just with a...

Not sure I understand full transaction log properly .Have you ever had a transaction log or full backup at any time between Dec -06 and June 12..

Mike

Not sure I understood you correctly.My database is in recovery mode because T logs are periodically applied to it.

The question was looking for a way to...

If the utility is taken out of the equation do the users login without issues or the have the same/different errors.

Mike

Can you disable the jobs or unschedule them without issues?

If so ,do that,create new ones that work then continue troubleshooting.

What is the result of

select @@servername

Mike

also check if there is a firewall

Drop and recreate the maintenance plan jobs

Mike

This may be what you are looking for ...

http://www.databasejournal.com/features/mssql/article.php/3379901

If you have a rep contact him/her, I bet they will give you all the help you need for free and fast too.Not sure how many times we have...

SP4 has been out for more than two years and as far I know is pretty stable

Mike

Thanks for your time  Jeff  will be looking into the script

Thanks for your responses guys

Should have mentioned that the trans logs are backed up every

1/2 hour.And would like to keep them that way just in case...

Question

Are you using any third party tool?

Can you save the output of the jobs in

a file and see what it says?

Mike