A full backup doesn't mark the space in the log file as reusable.  Have a read through this, and let us know if you have any questions.

I really don't know what's happening, then.  If you're more interested in fixing this than finding out why it's happening, check that the schedule isn't being used for any other...

I don't think you understand.  Please have a look through this.  You may find that it points you in the right direction to solve the problem yourself.  If...

Is the job running to the schedule that appears to be disabled (with the same frequency and at the same times)?  Have you run the sysjobhistory query I posted earlier...

Not that many rows, then.  But not much we can do without the execution plan.  Have you used sp_whoisactive to check for blocking while the query is running?

John

This will ready your table only once, instead of twice as your query does.  I think there'll be extra sort operations, though, so you'll want to test whether the IO...

This will tell you who is running the job - that may give you a clue to how the job is being run.  (Don't forget to substitute in the name...

Javed

Please post the actual (not estimated) execution plan.  How many rows are in each table?

John

SELECT
     a.name AS AlertName
,    j.name AS JobName
,    s.step_id
,    s.command
FROM msdb.dbo.sysalerts a
JOIN msdb.dbo.sysjobs j ON a.job_id = j.job_id
JOIN msdb.dbo.sysjobsteps s ON j.job_id = s.job_id

Mike

The best way to find out is to try it!  From my experience, the answer to all your questions is yes.

John

Jon

No, you can't do that, since MTH_NUM is not guaranteed to have been evaluated when the CASE expression is evaluated.  You'll either need to repeat the whole DATEPART...

Sanaz

Go to Linked Servers in Object Explorer, then open Object Explorer Details you can then select all the linked servers and hence script them out in one go. ...