Sorry for the delay, I've been away.

I've added space so circumvented the issue but it's annoying. I find log shipping on 2005 quite buggy though it may be my...

Yes, it does, the files are deleted after 5 days. I just can't cut that down at all.

Oh my goodness, John, you are a genius! Who knew?! Sorry I didn't properly read / think through your first post. Lowell, you are a very patient person! ...

Thanks John but I can't remove it.

My agent job outputs to that dir as the first step. It has to output to that dir for various reasons related to...

Perfect! Thank you! I had a feeling I was missing something.

🙂

Hi, I'm sorry I forgot to say thanks.

That's great. It's quite restricted where I work so we don't have ps on this server but I've been able to...

Well, I can report that the error has gone. I'm not sure which of the following steps taken previously 'resolved' the issue, but last night I re-re configured log...

Thanks for the response.

The DR db is in standby / readonly.

The log shipping is set up for 'standby mode', 'disconnect users when restoring backups'.

I have a few...

Ok, thanks for the advice. I'll do as you suggest and plod on with the other metrics / baseline comparisons.

Would still be interested in the answers wrt physical drives...

Perfect. Thanks Eugene.

SELECT db,

SUM(CASE WHEN type = 1 THEN size ELSE 0 END) AS [Type1],

SUM(CASE WHEN type = 2 THEN size ELSE 0 END) AS [Type2],

SUM(CASE WHEN type...

Thank you both!! Appreciate you taking the time.

🙂

SELECT a2.a, D.a

FROM D

LEFT JOIN

(

SELECT * FROM A

WHERE A.b = 1

) AS a2

ON a2.a = D.a

WHERE D.a IN (1,2,3)

oh dear. i think the act of clarifying in a post...

Actually to give context, this is the wait_type for a spid issuing a checkpoint since yesterday that's blocking a large rollback & killing my server.

it's presumably related to a full...

Thanks, that's great info.

Appreciate your time.

🙂

Thanks for your time, we do have the default trace enabled. But, unless I'm missing something which is quite probable, I can't see that the relevant SQL is captured....