you actually configured it to listen on 1433?

after the recovery model switch you may run a differential backup and use this along with the existing full backup to initialise the new secondary

not an error I've ever seen before.

Can you provide more detail on the cluster configuration, is this a new cluster or are you running the validation on an existing...

need to be looking in this catalog sys.dm_hadr_database_replica_states

its the combination of the IP and port that should be unique.

You can listen on the same port as long as its on separate IP addresses

curious_sqldba (2/19/2015)

---

I have 2 brand new HP servers, there configuration is exactly same including array configuration. On serverA i have installed OS on C drive which is RAID 1,...

by partition you mean a windows logical disk??

have you checked the hotfix log for further details of the issue

Ideal that the SP...

so its not clear, do you have a partitioned table?

daniarchitect (2/19/2015)

---

Experts,

Select @@Servername is showing 'GEBPC\GEBPC'

where as the default sql instance shows 'GEBPC'

how can this happen?

please add your best intelligent guess here.

this created an issue while creating a linked server...

nice article Steve, but would be helpful for readers to see the T-SQL behind the backup and restore commands I think

Cant remember exactly which catalog its in i'll dig it out and post it back.

was the cluster validation report clean??

my temptation here would be to just reinitialise the LS plan once I've confirmed the Primary is healthy