Ohh its BizTalk..ummm.Lets see if somebody answers it.

From my personal Experience, I will say 'clustering'. But as stated above it depends upon several factors as to which method one should use for High Availability.

Personally I haven't had experience with RAID 50 SANs but lets check what others has to say here.

But out of curiosity, any specific reason of using 50? I believe, you...

query on database specific DMVs and server/processes DMVs can best fit here.

yeah , that has to be but under different environment where lets say servers has different numbers of CPUs. how exactly the TempDB configuration can impact after failover.

This generally happens immediately before you server bootsup or shutdown.

And

if somebody manually stoping the services from Service console.

As stated by other check the windows event logs for more details.

so I. but thanks for reply.

BTW did you ever come across with any situation where in A/A node the number of CPUs are not equal on both nodes?

no confusion silverfox, I said if nothing works. 😀

Silverfox (9/18/2009)

---

I would have thought someone as talented as you would know this.... 😛

It is best...

and if nothing works, suspend the Services from Primary.:hehe:

Can you explain it a bit...

Steve Jones - Editor (9/17/2009)

---

If you want to do a maintenance task, I'd check integrity first (if you have time), then backup, then maintenance cleanup, then history cleanup.

If you can't...

If provided permission the same way, are you able to view any other database (which has not enabled any encryption) from the same user id?

As already stated by others just do a a search for "SqlWb.exe" (if using 2005) or SSMS.exe (if using 2008) and change the path accordingly.

There shouldn't be any other problem.

oraculum (9/17/2009)

---

Ok its worked! One i wont forget!

So all I have to do now is re-instate all the FK, PK and Indexes and Move the documents table back from an...