Thanks for the response,
I have been preaching this gospel that this failback is manual and is recommended practise for it to be manual but i SQL is being compared...

the order of etl should then be in sequence with the foreign keys. by comparing it's key to the table which holds the same key as primary key.

Hi

If this tables are linked to an application or applications, the application process flow should guide you on what gets captured first. So perhaps if you enable a profiler and...

That part I understand, but can I upgrade sql without using slipstream option if I have SQL 2014 SP1 image?

Thanks, and is it true that upgrading SQL 2008 R2 to SQL 2014 on windows 2008 R2 SP1 can only be done the Slipstream way?

Also supply us with error logs from cluster manager, look for the option called critical events.

Any maintenance plans for reindexing or index reorg schedules?

Try using a different SQL install media or re-downloading a fresh copy, your install file could be corrupt especially when there's no thread in the internet of such. If you...

Thanks i'll keep that in mind.

Any thing I should look up for when upgrading the OS to SP1?

does it have any impact on my current SQL 2008 R2 SP2 enterprise?

SQL 2008 R2 enterprise with SP2 and CU.

the current environment is running Windows 2008 R2 enterprise.

One more thing, ALWAYSON availability groups are only available on windows 2012 or can I...

Thanks

keshab.basnet (7/24/2015)

---

Dear Sir,

I have attached the snapshot of Ip configuration of Node1 , Node2 and DC.

Node1 and Node2 has both private and Public ip.

Now i have recreated cluster and reinstalled...

May I ask if you can use different IP ranges as well, it shouldn't have any impact to your underlying problem but it's recommended

to have public IPs on 192.***.*** range...

Hi

Thanks for the feedback.

I see your subnet mask configurations are different for public and private IP are different, can you please use the same subnet mask IP for both...

You need to restart the SQL Server browser service if it's already running otherwise start it if it's not running.