are the disk\file paths different between the 2 servers?

are you cloning for testing purposes, if so have you thought of cloning the whole server to a virtual machine?

saidapurs (2/21/2012)

---

Hi All,

I got the solution after seeing error log in Witness server.....

Error :-

Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error:...

hmm, not sure I'd use the index physical stats dmv to get table usages, this should work though

selectobject_name(p.object_id) as TableName

, p.rows

, a.total_pages * 8 as TotalKB

, a.used_pages * 8 as...

could you explain why you have set this

dbrackin (2/22/2012)

---

I am learning SQL admin, took online classes and studing books and on the job. We have a new 2008 sql R2 standard database I set up and a...

How many log shipped databases ate we talikng about total?

It sounds like your main aim is to provide availability?

What share\NTFS permissions are set for Certstore?

When you launch the sql server installer exactly which option are you selecting?

Are you trying to use the same group for the new instance on node b that is already in use for the instance on node a

You're welcome

Sapen (2/21/2012)

---

I was wondering how the cluster would appear in my scenario (behavior of passive node(Node C)). On one active node(Node A) I want to have instance1 and on the...

No you cannot,...

have you verified connectivity\latency between the instances

Completely understand, but in my experience pointing out their flawed maint plan and correcting it should serve to gain you a little kudos and maybe even an extension to your...

Quite agree, as I said I did not design\deploy the current cluster I work with, if I had I would not have used dedicated heartbeat NICs 😉