Thanks, I realise it is deprecated and have recommended not using it but the client has a love of the idea and I am just trying to get it working....

Embarrassing solution found. Client gave me the standard media and not the enterprise media. Not the first time I have had something embarrassing be the solution and won't be the...

Time got away from me. A few quick responses:

Elliott: You could write an executable installer

Yep that would be fine for my current stuff, I just wonder about if you had...

Yes we did.

I don't remember how 🙂 Give me a few hours to chase up the details.

I remember it ended up being a PSS fix which was nice to...

Thanks for that. They did end up giving up on the recovery and went to a couple of weeks old backup. There are even rumours that the backup plan I...

Yes the database is attached currently.

The current error is when you do a select from any table in the second or third data file it errors. (Sorry I don't have...

I believe attach rebuild is 2005+

The current log file created by the clients faffing around actually attaches fine.

Smells to me like they have managed to redo the mdf so that...

The agent is part of the domain (it is a clustered instance).

The agent gains access via the domain group SQL_Agent.

Note that my account (which works fine) is a member of...

Not 100% (just copy and paste of mail from client) but assuming they mean the primary and mirror as the remote replication servers would not know anything about the primary...

Well looks like it is resolved. From my client:

"It seems we found the problem for the replication with mirroring. If we

make sql port number same for primary server...

Well I have set up the mirror and tested that, still no joy.

I have followed all the MS doco on setting it up and verified the setup with PSS.

I had...

I will give that a try.

I have run the log reader in command mode and when I down the primary it does only try the primary.

In the startup parameters it...

Bah I should just go with my feelings rather than trying to confirm my opinions.

Restarting sql in single user mode does give local admin sa on sql (well on my...

I think that censorship tends to send a message about a corporate culture which I am not happy working with.

I am not happy unless trusted. Sure I will spend massive...