Thanks for your reply, that certainly explains what is happening.

It's a shame there is no "nolog" option for index rebuilds in FULL recovery mode. Having >1Tb tx log disk space...

Thanks Derrick and Elliott, that's a much better way of doing it. Wish I'd known about that way before!

OK, will do. Code was originally written for SQL 2000!

There is error handling, here's a code extract:

exec (@Command)

set @LocalError=@@error

-- If there's a problem record it in the event log

if not @LocalError = 0

begin

set @ErrorMessage= 'An Error'

if @ServerStatus = 1

raiserror(@ErrorMessage,16,1)...

I'd like to be able to dynamically adjust the memory allocated to each instance running on the individual nodes.

So, for instance, if one node fails and the instance(s) failover to...

ah, ok, thanks Howard. I didn't realise that.

yes, I followed that, but it seemed to be the sql server service account that did all the work so the resource govenor didn't have much affect

thanks Steve. So, are there any reasons to not compress?

Hi, how are people finding the CPU hit when running compressed backups?

I tried to create a specific login, limited to max cpu 20%, to restrict the affect on CPU, but...

Thanks Paul

If (and I'm not convinced yet!) we go down the mirroring route, I will investigate using this DMV.

Regards

Andy

Thanks Paul

Does that catalog view exist on both servers?

Andy

Thanks Steve

Andy

Thanks Kenneth and Jeff, appreciate the prompt responses.

Will suggest your recommendations.

Andy

Thanks for the reply Kenneth

Definitely shows up as a deadlock, which is why I'm a bit confused.

I will pass your suggestions on to the developers.

Andy

No, not sure what it would tell me though??