Actually, just read back through the thread. I was thinking about a totally different log shipping issue we had at the end pf last year.

We never did get this issue...

Sorry, we were still using SQL 2000 at the time, and that had to be Enterprise if my memory serves me correctly.

Hi,

The problem our end was that we had SQL Standard installed, but log shipping only work on Enterprise.

Nopt sure if that's the same issue with you?

Farren

Can anyone help with this?

Ok, thanks for that, but i'm still a bit confused (I'm a pretty new SQL admin btw 🙂

On the target server the login and db user already exists. So do...

Hi

The same login already exists on the target server but I assume the SID doesn't match any more (which I would expect when restoring a db from one server to...

Just wanted to update this in case anyone else has a similar issue.

Basically what was happening was that a default tracing job was jumping in before I could log on,...

Hi Grant

But who/what is using up the other connection?

The reason I want single user mode is because I want to try testing a restore of the master database which I...

I have tried everything.

No matter what I do, and no matter how many other processes I kill off I still always get the same message telling me that only one...

Additionally, I sometimes get the error that only one admin can log on.

However, even when I just get the error in the prev post, the log still caontains the following...

Not at all Andrew, it's all a learning exercise for me anyway 🙂

Any help is always appreciated.

Ok, so I have had a look and sure enough there is a table that has two columns set up as UNIQUEIDENTIFIER.

But a) the table is empty/

And b) the same...

Thanks Andrew, that gives me some good stuff to be looking into.

I was hoping this was going to be simple 🙂

Farren

Well it's not quite a wizard in 2005 but I am using Management Studio to do the config (right-clicking the db and going to properties/log shipping).

Thing is, in test this...

Thanks for that.

To be honest I have already read through that link and had no problem doing this in

Test. I have the log share dirs set up and they...