There are 3 non-clustered indexes on that table, 2 of which use...

Thanks for your reply, Ken.

Your code worked (and is certainly a lot neater than my own attempt). However, the script doesn't run any faster and still takes just over 2...

Thanks for your replies.

AlexSQLForums (2/9/2011)

---

That timeout parameter is tricky.

It depends on the time it takes for your cluster to failover in order for your witness to keep on mirroring...

Will do - thanks Gail.

Paul/Gail, thanks very much for both replies - very helpful.

I should've mentioned that we do already know the cause of the corruption, which was a failure of a SAN controller....

Gail - Thanks for the confirmation.

Jpotucek - I've used 7Zip before, so I might look into doing what you suggest. Thanks.

Jeffrey - We already currently use LiteSpeed for these databases....

Actually, funny you should say that, because the work has been postponed, so I now have time to fix the corruption first - thanks for the tip.

So how about reducing...

Gail - we'll be using attach>detach for most of them. However, we will be using backup and restore for one of them that has slight corruption - we'll be fixing...

Cracked it :w00t:

I didn't have to create a new alias in the end, but it appears that it was an alias-related issue.

The instance I was having a problem with is...

Mary - I have completely re-booted the server to try to fix the problem, so I assume that would have forced the service to get a new process/session ID? I'll...

Thanks Dare to Fight...if I try to start it using Services, I get the error:

The SQL Server Agent (SQL2005) service on Local Computer started and then stopped. Some services stop...

The scripts returns is_broker_enabled=1, so I assume it's enabled.

I had a read of the link you sent me, but it looks like that only applies to starting the agent service...

Yes, running your script returns:

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Configuration option 'Agent XPs' changed from 1 to 1. Run the...

Thanks for the reply, magasvs.

I've seen that suggestion a few times and yes I did try that. Unfortunately, 'show advanced options' was already set to 1. I set it to...