yeah I thought you might say that... 🙂

so this means I will have to restore a backup of the DB and then restore the log files after that?

I encoutered the same issue om my production server (SQL 2005).

To overcome the issue of receiving "failure notifications" from SQL Agent, I added 1 retry event under the Advanced properties...

Thank you for your info.

Another thing I was wondering about is this:

Will running Rebuilding indexes maintenance plan, decrease the number of deadlocks by any chance?

I checked the 'On success' action. Would have felt like an idiot if that was the case... But No, all settings are correct for on success and on failure.....

Thanks for your replies.

This also happens with my Transaction log backup files - a job that runs every 10 minutes.

It indicates that the Transaction log backup job has failed...

The request came in from a client. We provide them with an extract of the data in Excel format and then the records "repeat" as in my example.

They would like...

yeah i thought auditing would have to be the way out.

Just by the way - you said "if not too much time has passed" i can use the default trace....

Thanks - you were right - the view was referencing another DB - So I: GRANT SELECT ON tableName TO userName (for that DB)

and it works fine

Thanks

Thanks for the replies.

One more permission related issue: If I execute this: EXEC sp_addrolemember 'db_datareader', 'User_Name_Here'

It give the user SELECT permissions on tables , but not views.

How can I...

Even though the status is "sleeping" ?

Could this be adding to the fact that the CPU is flat lining?

Can I kill these processes and will that solve my problem?

Well actually it's not me that wants to do this.

The question came from a developer working on a development server.

I guess he just wanted to know for interest sake -...

No the process is not being blocked. Here are some column values for that process for sp_who2.

Status, Command, CPUTime, DiskIO, ...

Well it's been over 5 hours now AND STILL running 🙁

Thanks for all your replies but I was now thinking: As mentioned it does UPDATES and INSERTS to tables....

I am getting the same error - says the job fails, but the log files are created in any case.

Maintenance history shows it was successful but the job history shows...

Thanks - I tried your suggestion -works just fine.

Appreciate it!!