Ian,

That does just the job, thank you so much!

:w00t:

Christophe

Thank you both! You've both been a great help.

Apologies for my late reply, only just got back in the office.

Many thanks Durai, you've been most helpful.

OK, thank you.

That makes sense now. Will that growth be permanent after the rebuild has completed or will the database reduce in size again once the rebuild has completed?

I...

No, I'm pretty sure that option isn't turned on.

Cheers.

I finally nailed it!

The problem turned out to be the login account used to run the MSSQLSERVER Service. I had the account for the agent service on both machines...

Initially I was trying to backup to a folder on the secondary server and it was failing.

Since changing to a folder local to the primary server the backup completes successfully...

He/She dint say that the "-" wont be pesent, right? The OP was concerned because of the fact that the length of the string before and after "-" is incosistent.....

Ah, thank you both!!

See I knew it would be easy but that I was missing some understanding somewhere.

So in actual fact what I was doing would have worked had there...

I had the need of doing something similar but for different reasons.

It's not an ideal solution but perhaps you could tinker with it and see if you can make it...

Thank you Greg, I think that will work very well.

Paul

Ah, that's great - thank you very much. 🙂

Paul

I hadn't thought about using a seperate monitor process but I reckon that would probably work just as well.

If you have any ideas on how to accomplish this (I'm not...

No specific reason except that my SQL knowledge isn't that great and until you mentioned it I wasn't aware you could do that :ermm:

I've had a quick look at sp_send_dbmail...