Hi Jack

I'm down to 3 weeks remaining history so I can't really go any further, the issue is I'm not getting any space back, the DB is continuing to grow,...

Hi

Not seeming to get any help with my post, I have found the following post http://johnsterrett.com/tag/sysmaintplan_logdetail/ that suggests I truncate the table.

Can anyone at least take a...

*bump* anyone help?

P.s, just checked 4 servers, all have SQL Server Browser running as NT AUTHORTY\LOCAL SERVICE and I'm not changing them. It's def the default.

Oops, what a noob, thought my post was chewed up...didn't see page 2.

Apologies, ignore the above^ I just tested and IP\instance works fine.

If I can connect the next time, do you suspect DNS? I'd be surprised myself tbh.

Ignore above^ just tested IP/instance and it worked fine. I'll give that a shot.

If I can, you think it's some DNS issue? Just seems so random and intermittent to be...

I'm going to show my amatuerness now...can you connect to an instance using IP? For example 172.20.2.200\instanceA? If so, no but good idea, I'll happily give that a go.

Ok thank...

Ok, that's odd as I'm pretty sure I left as default...

No, nothing. And it's not always there and never on all instances, very weird. Although it only takes me seconds...

Apologies, yes that's what I meant by local, the NT AUTHORITY\LOCAL SERVICE account.

Can't see that being a problem due to the issue occurring as intermittently as I'm getting though. All...

Local service

In addition, I sometimes get the following on one/some instances

Login failed for user DOMAIN\ServiceAcc. Reason: Token-based server access validation failed with an infrastructure error. Check previous errors.

There are no other...

Thank you GSquared!

That was much more helpful and informative, apprecaited greatly.

Many thanks

Mark

I thought I'd let you know how things have ended.

Thanks for the advice, but I chose not to take it. The two instances where the instance (bin, logs etc) was...

Ok, any reason why you wouldn't bother with a repair?

Also, if I'm recreating the instances, where do I put the install, with the OS this time?

Thanks for help, a little...