Hi Grant

Thanks for the reply. I was using term "deadlock" loosely. There was no internal deadlock detected by SQL Server but we did indeed have a blocking chain and the...

Thanks for your quick response.

I agree that a good network should be a pre-requisite but it is still a point of failure.

In exactly the same way a reliable motherboard (or...

Did you make a decision on this?

We have the opposite situation at the moment.

We currently have Standard licences but are considering upgrading to Enterprise.

The main driving force is Asynchronous mirroring...

Did you make a decision on this?

We have the opposite situation at the moment.

We currently have Standard licences but are considering upgrading to Enterprise.

The main driving force is Asynchronous mirroring...

Seem to have got beyond this problem now but still not sure what was the exact cause of the above error.

Would make the following points though which don't seem to...

Thanks both for input.

I am definitiely choosing a different

Primary and Secondary Server on the form.

But it was creating all 3 jobs on the Primary.

No it didn't work like this.

I...

Thanks again for the response.

SQL Server Version is 9.00.3294.00

(SQL Server 2005 SP2 Cumulative Update 10).

Yes I do mean "right click database--> properties---->Transaction log shipping".

Can you confirm that when YOU go...

Thanks for the reply.

Yes 2005.

To your second question, No.

I want primary on one server and secondary on different server.

My point is that if I try running the "wizard" it sets...

(Would someone please continue this Post. It seems to be a common

problem area and so far there is no satisfactory conclusion.

How can it be so difficult to implement a standard...

Why has this post been left dangling?

It was just getting interesting.