Hello Bobby,

maybe you could recomend some links where we can find these practice tests for free?

Thanks in advance

For detailed information refer to http://support.microsoft.com/?id=314546

Yes you can see these logs but not in enterprise manager. I suggest you to use sql profiler in that case. Or if you have transaction logs then you could...

Ok. Thanks all who tried to help me. It looks like I've got what I needed

That's what I wanted to know. You really helped me in my doubts. Thank you

Thank you phillcart. Yes I have

But I've found the info somewhere where it was said that before installing virtual server you have to install sql server instances on both nodes....

Yes the second one. So how is it... After installing the MSCS in order to have sql active active cluster, during sql server setup I must choose virtual server instead...

Thanks for your reply. MSCS is already installed. I need to install SQL server active active configuration.

I don't understand how many SQL server instances I must install. For example If...

Thanks for your replies. I've read a lot since my first post on this topic, but I still have one question:

Active/Active configuartion on two nodes... Do I need to install...

Well I guess that without sa server role it's impossible to manage sqlserveragent jobs

It's my own opinion

I'm sorry to trouble you but how is it... There must be only one virtual server or two, if I need to run two separate db at one time on...

continued...

And what about log shipping to s3? After failover proccess will it work normal? I mean S3 will copy s1 and s2  *.TRN to s3 where they will be restored...

So how i understood from yours explain there are two virtual servers V1 and V2. V1 has primary s1 and secondary s2(s1s). V2 has primary s2 and secondary s1(s2s). And...

Ok, maybye I explained my problem not clearly enough. I'll try again

There are three nodes: S1, S2, S3. S3 is designated almost for log shipping only(standby server). S1 and S2 are sql...

Hello,

what I suggest you is to create cursor with your DB names and  to run DATABASEPROPERTYEX( database , property ) function inside that cursor