Kevin is right..

Thanks

So I think the only option is to break mirror and let them do the testing..and set up the mirroring again..

No! They will not be. Changes made on new principal(Server B) are not needed..

Idea is When we reverse it will be in sync with Old principal...

Thanks Very Much!

Hello Dwain,

I would need machines that doesn't have all these three groups also.

This is an Ad-hoc query that runs rarely once in quarter or so..

Thanks In Advance!

Hello Nevyn,

Is there a way I can do to this query and get the machines that doesn't have any of the groups?

Machines with all groups missing.

Thanks In Advance!

Thanks very much. Really appreciate your help!

That's what I was looking for...

Thanks Again...

Sorry. I said it wrong all of the machines should have one ore more groups.

Thanks again...

Hello Wee-Lin,

Did you happen to find resolution to our problem i am curious about the same thing?

Thanks,

Thanks very much!

Kenneth, an excellent article!Thanks,

I have the same question

"how would the implementation steps differ, if at all, were both ServerA and ServerB using the same SQL Server Service Account?".

Thanks,

Total Server Mem and Target Server Mem are almost the same thing..Does it mean it's using 6gb and it needs more...

thanks....

Thanks Everybody ..on this.

But my question is .

If somebody comes to me and asks how much memory SQL Server is actually using out of the allocated how would i answer...

But in this case i am seeing both Total and Target same.

What ever the max memory is set to...

I want to know..if it's having pressure...

Thanks,

I did try all of these...they are working..it's quitting as of there is some limitation some where..i am thinking at present on the tape..but i cant prove that because there...