not sure what you mean by 'sql response'.....

can you please elaborate?

problem has been resolved

we have 3 SAN drives and they were assigned as a resource

to cluster group ip address.

as soon as all these 3 drives were assigned to sql virtual...

Thank you ALL!!!!!!!

I'll try that.

system 1

Resource Group ...

thank you very much for your time and help!!!!!

we have 3 groups:

CL1

1. cluster group

2. msdtc

3. sql

actually both systems have sql installed on sql group, not on the cluster group

during...

I did checked the options and settings for both environments, like

Group:

Resources:

- Cluster Name

- Cluster IP

- Disk X

they are absolutely identical ( ofcourse the have...

QA

SQL VIRT Name QA1

InstanceName

NULL

IsClustered

1

MachineName

QA1

ServerName

QA1

ComputerNamePhysicalNetBIOS

ND1

===================================

PR

SQL VIRT Name PR1

InstanceName

NULL

IsClustered

1

MachineName

CL2

ServerName

CL2

ComputerNamePhysicalNetBIOS

ND3

-----------------------------------------------

most likely the cluster\windows configuration was done differently.

during the installation we chose default for instance name (so it should be a machine name)

the solution...

Here is more details:

Windows 2003 standard, sql 2005 sp2,

QA environment:

1. Cluster group name - CL1

2. Consist of two active/passive nodes

ND1...

Here is more details:

Windows 2003 standard, sql 2005 sp2,

QA environment:

1. Cluster group name - CL1

2. Consist of two active/passive nodes

ND1...

i understand that...

I'm just trying to find an answer why even though i follow the same

installation configuration, one of my clustered sql server shows in properties name

the same name...

no sir, i didn't

thanks !!!!!!!!

here is the story:

i am doing full backup to disk, daily

then Data Guard backup software does the backup to tape for those .bak files

it has an option, on success start...

wow, so simple and so great!!!!!!!!

nice to be smart... 🙂

Thank you

thank you, Sir