Russell, thanks for that, but logshipping wont replicate data outside of the database either, and mirroring will copy everything logshipping does.

This document from MS themselves recommends mirroring , although statements...

has an update stats been run since the upgrade?

run updateusage as well.

edit - didn't see neeraj has said the same thing - so I second that.

May the fourth

be with you

well that will teach me to post on something I haven't done for a while, still least I had the sense to put AFAIK.

Still sounds like it will be cheaper...

AFAIK you have to start with a snapshot to initialise the subscriber. No way round that.

if you have got failed login auditing turned on and you don't see login failures in the log, it ain't getting as far as sql. 🙂

I would say its not getting as far as SQL, so look elsewhere as Dan says.

thank you.

now to convince the sharepoint guys that MS doco can be less than perfect............

Lynn - I would not ask such a newbie question.

I know how the databases fail over, automatically or not, I was just looking for a second opinion on the...

sorry Lynn, thanks for replying but I think you have misunderstood the question: -

a client can use either SQL Server Native Client or .NET Framework Data Provider to connect as...

Lynn,

agreed - for the databases, thats a no brainer.

but what about the client automatically repointing to the mirror when the principal goes down, thats my...

PearlJammer1 (5/1/2013)

I am considering adding a secondary tempdb file to my datawarehouse to hopefully improve performance. I am aware that I have to size this secondary file to the same...

what error do you get?

no probs

if its in restoring state then 0.

if in standby\read only then whatever your server setting for max connections allows